Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Need help with group filter
I have the following filter that isn't returning the right result:
filters[0] = new nlobjSearchFilter('internalid', 'contact', 'is', input.id);
filters[1] = new nlobjSearchFilter('firstname', null, 'contains', input.searchValue).setOr(true);
filters[2] = new nlobjSearchFilter('lastname', null, 'contains', input.searchValue).setOr(true);
filters[3] = new nlobjSearchFilter('companyname', null, 'contains', input.searchValue).setOr(true);
filters[4] = new nlobjSearchFilter('email', null, 'contains', input.searchValue).setOr(true);
filters[5] = new nlobjSearchFilter('entitystatus', null, 'anyof', leadStatusCodes);
This is not working how I would want it where I really want:
filters[0] and (filters[1] or filters[2] or filters[3] or filters[4]) and filter[5]
Is there a better way to do this that works.