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.
nlobjSearchFilter and 'notequalto' ???
Hi-
We have a search in a script that is searching a custom record. Anyway, one of the fields (a list field) in the record is named 'custrecord_renewalop'-- which is a list of all of the opportunities for the parent customer (the custom record is child to a customer). Anyway, one of my search filters needs to exclude records which don't have a value in this field...
I have tried:
filters[1] = new nlobjSearchFilter('custrecord_renewalop',null,'isnotempty',null);
filters[1] = new nlobjSearchFilter('custrecord_renewalop',null,'isnot',"");
filters[1] = new nlobjSearchFilter('custrecord_renewalop',null,'notequalto',"");
filters[1] = new nlobjSearchFilter('custrecord_renewalop',null,'noneof','%NONE%');
0