Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Filter Search for Sales Order Status
Hi, I've been honing down a scripted search (SuiteLet) and the last issue is with filtering for a particular set of statuses - partiallyFulfilled and pendingFulfillment, which are in the format returned by the search with this filter off. After many iterations and combing through he documentation, this filter will yeild zero results:
var filters = new Array(); var stati = new Array(); stati[0] = 'partiallyFulfilled'; stati[1] = 'pendingFulfillment'; filters[0] = new nlobjSearchFilter('status', null, 'anyOf', stati, null);But if I flip the operator to 'noneOf' then I get the full set of orders that match any other filter criteria.
It feels as though I'm using the wrong format for the status, but trying "Pending Fulfillment" or "Sales Order:Pending Fulfillment" or even the WS enum value "_pendingFulfillment" has the same effect.
0