Hello,
I'm setting up a search filter and I'd like to both use AND/OR logic and the setSummaryType method. Can I do this?
I think my question is really, how do I implement AND/OR when building the search filters as an array? For example:
filters.push(new nlobjSearchFilter('amount', null, 'greaterThan', '1').setSummaryType('sum') filters.push(new nlobjSearchFilter('custbody_batch_email', null, 'is', 'T')); filters.push(new nlobjSearchFilter('email', 'customer', 'isnotempty'));How would I add AND/OR logic to the above?I'm familiar with setting up AND/OR like this: filters = [["subsidiary","anyof","1"],"AND",["custbody_class","noneof","17"],"AND",["mainline","is","T"],"AND",["amountremaining","greaterthan","0.00"],"AND",[[["type","anyof","CustInvc"],"AND",["daysoverdue", "greaterthanorequalto", "180"]],"OR",["type","anyof",["CustPymt","CustCred"]]]];
But I don't know how to combine them. Can I?