In suitescript 2.1, I'm creating a "systemnote" se...
# general
a
In suitescript 2.1, I'm creating a "systemnote" search. Including a filter in the filters array like this
Copy code
["field", "anyof", "custbody2"]
Causes there to be 0 results, but if I leave that filter out, then we find many results, some of which have the "field" result column with the value "custbody2". What is the correct way to filter on a specific Field for a systemnotes search, to only include system notes in the results if they are about the Field with ID custbody2 (label is "PO Status")?
1
b
make the search in the ui first, then load the search in script so that you can inspect what the filters look like
1
a
Thanks, that made the difference! I got it to work. I had to change the filter to ["field", "anyof", "CUSTBODY2"] So that "CUSTBODY2" is capitalized. It doesn't work when it's lowercase "custbody2".