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.
Search filter using AND/OR and setSummaryType
Hello,
I'm setting up a search filter and I'd like to both use AND/OR logic and the setSummaryType method. Can I do this?
I think my question is really, how do I implement AND/OR when building the search filters as an array? For example:
filters.push(new nlobjSearchFilter('amount', null, 'greaterThan', '1').setSummaryType('sum') filters.push(new nlobjSearchFilter('custbody_batch_email', null, 'is', 'T')); filters.push(new nlobjSearchFilter('email', 'customer', 'isnotempty'));How would I add AND/OR logic to the above?
I'm familiar with setting up AND/OR like this:
filters = [["subsidiary","anyof","1"],"AND",["custbody_class","noneof","17"],"AND",["mainline","is","T"],"AND",["amountremaining","greaterthan","0.00"],"AND",[[["type","anyof","CustInvc"],"AND",["daysoverdue", "greaterthanorequalto", "180"]],"OR",["type","anyof",["CustPymt","CustCred"]]]];
0