RE: What is the correct syntax for creating a Search that uses the Search Operator ANYOF
Answered
When creating a Search with the following filters,
var invoiceSearch = searchModule.create({
type: “invoice”,
filters:
[
[“type”,”anyof”,”CustInvc”],
“AND”,
[“mainline”,”is”,”T”],
“AND”,
[“number”, searchModule.Operator.ANYOF, invoiceNumbers]
],
columns:
[
searchModule.createColumn({name:"tranid", label: "Document Number"}),
searchModule.createColumn({name:"createdfrom", label: "Created From"})
]
Where invoiceNumbers is [“123″,”124″,”125”]
But I get an error,
{“type”:”error.SuiteScriptError”,”name”:”SSS_SEARCH_FOR_EACH_LIMIT_EXCEEDED”,”message”:”No more than 4000 search results may be returned at one time from nlobjSearchResultSet.forEachResult(callback)…}
I was expecting 3 results not 4000+, Am I structuring my filter correctly?
Use filter expression for multiple freeform text values ex.
var s = search.create({type:’invoice’})
var f = [
[‘tranid’, ‘is’, ‘INV1’],
‘OR’,
[‘tranid’, ‘is’, ‘INV2’]
]
s.filterExpression = f
s.run()
