Retrieve Data: Can I filter records by fields with no value in CloudExtend Excel Data Management for NetSuite?
Retrieve Data: Can I filter records by fields with no value in CloudExtend Excel Data Management for NetSuite?
XLNS | Filtering fields with no value
Written by Justine Burdo
Updated over a week ago
This can be done by entering [[@NONE@]] in the value field when creating a filter.
Ex. To get a list of vendor bills where the location is null/empty, create a filter with the location field and enter the value as [[@NONE@]] (1) instead of choosing from the drop-down. Hit Save (2).