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.
Summary Search Filters
Hi--
I've come across a use case where I need to filter on the result of an aggregate operation and thought to use the new nlobjSearchFilter(...).setSummaryType(...) method to do so from my script. Unfortunately I've run into problems where I keep getting invalid search criteria and I wasn't able to find the question posed elsewhere here.
I'm working with a projecttask search as shown below:
targetTaskFilters[0] = new nlobjSearchFilter('internalid','job','is',projectId); targetTaskFilters[1] = new nlobjSearchFilter('assignee',null,'greaterThan',0).setSummaryType('count'); targetTaskColumns[0] = new nlobjSearchColumn('internalid',null,'group'); targetTaskResults = nlapiSearchRecord('projecttask',null,targetTaskFilters,targetTaskColumns); What I get in response is:
Title SSS_INVALID_SRCH_FILTER Type System Date & Time 8/10/2011 3:12 pm Details An nlobjSearchFilter contains invalid search criteria: assignee.
0