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.
NetSuite support says that the reason this is failing is that 'greaterThan' is not a valid search operator for the 'List/Record' type, but in their answer they seemed to have neglected the fact that this was a summary and not a normal search. The documentation for the .setSummaryType(...) method suggests, though doesn't explicitly say, that the search operator is 'of' the aggregate (i.e. the setSummaryType('count') result from my example) and not the filtered field as normal. This is what I would expect because that would be the point of identifying a summary in the context of a filter in the first place. However does, as support maintains, the search operator really have to be compatible with the base field type being searched in addition to the identified aggregate? That would seem odd as I'd never be able to query the 'count' of anything other than numeric fields. Something just isn't adding up here so I'm hoping to either find out that I'm missing the point of the function or that support's assertion is incorrect and either I've got the syntax wrong or there's some other problem.Thanks,Steve