I am trying to do a saved search, where I check if...
# suitescriptb
Benjamin Cookson
12/29/2021, 4:29 PMI am trying to do a saved search, where I check if an associated transaction has a certain Document Number
["custrecord_byu_isp_location_link_trans.tranid","is","CS62050"]
When I use Tran ID or Number Text, I get this error ""name":"MISMATCHED_SEARCH_PARENTHESIS","message":"Search error: Parentheses are unbalanced."
If I use Number, I get too many results "SSS_SEARCH_FOR_EACH_LIMIT_EXCEEDED","message":"No more than 4000 search results may be returned at one time
Is there a way to filter by The Document Number when I am referencing a joined record?
b
battk
12/29/2021, 4:33 PMpick your filter carefully
battk
12/29/2021, 4:34 PMthe operators used for numbers are different than the operators for text
battk
12/29/2021, 4:34 PMdont use an operator for text on a number filter
battk
12/29/2021, 4:35 PMor a number operator for a text filter
battk
12/29/2021, 4:35 PMif you dont know how to tell the difference, build the search in the ui first, load it in script, then inspect its filters
battk
12/29/2021, 4:35 PMthe ui wont let you mixup operators
👍 1
b
Benjamin Cookson
12/29/2021, 4:38 PMThanks!
m
Mattias Uppström
12/29/2021, 9:01 PMI recommend this nice tool to export searches to suitescript:
https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp