Skip to main content
All CollectionsExtendInsights for Excel NetSuite EditionExtendInsights for Data Management NetSuiteRetrieving Data
Retrieve Data: Can I filter records by fields with no value in ExtendInsights for Data Management NetSuite?
Retrieve Data: Can I filter records by fields with no value in ExtendInsights for Data Management NetSuite?

ExtendInsights Data Management | Filtering fields with no value

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).

Records pulled are those vendors bills with null or blank Location at the header.

Did this answer your question?