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.
Syntax to search a checkbox field
Hi,
I'm trying to add a filter on a custom field that is defined as a checkbox. I can't seem to get the results I'm expecting.
Here is the filter definition:
filters[1] = new nlobjSearchFilter('custrecord_upgrade', null, 'isnot', 'T');
I've also tried:
filters[1] = new nlobjSearchFilter('custrecord_upgrade', null, 'is', 'N');
Does anyone have ideas on how to filter on a checkbox value?
(note: this is just a snippet. There is a filters[0] and the appropriate searchRecord. The search works if I remove the checkbox entry).
Thanks,
Brian
1