ANS-0006 · SAVED SEARCHES & FORMULAS
How to Filter NetSuite Saved Searches for ‘NoneOf None’ on Multiselect Fields
This guide explains how to correctly apply a 'noneOf None' filter to multiselect fields in NetSuite saved searches, addressing their text-based retrieval.
Short answer
To filter a NetSuite saved search for 'noneOf None' on a multiselect field, use a Formula (Text) filter. Set the formula to the multiselect field ID and the operator to 'Is Not Empty'. This approach correctly handles how NetSuite retrieves multiselect field values as text strings, ensuring accurate filtering for empty selections.
Scenario
When attempting to filter a NetSuite saved search to identify records where a multiselect field has no selections (i.e., 'noneOf None'), users may encounter unexpected results. This occurs because NetSuite processes multiselect field values as concatenated text strings rather than distinct list items during retrieval.
Solution
NetSuite processes Multiselect fields as Text fields when retrieving their values. For example, a Multiselect list of Countries would show something like this "CAN, USA, UK". To properly perform a "noneOf None" filter on this, users need to use a Formula (Text) filter where the formula is the Multiselect field ID and the operator is "Is Not Empty".
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support