In suitescript 2.1, I'm creating a "systemnote" search. Including a filter in the filters array like this

["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")?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you are trying to use a filter object in SuiteScript 2.1, but you are using the syntax for a filter expression. In SuiteScript 2.1, when creating a filter object, the

name

and

join

parameters should be separate. The

name

parameter should be the field you want to filter on, and the

join

parameter should be the join you want to use. In your case, you should create the filter like this:

javascript
search.createFilter({
    name: 'field', 
    join: 'systemnotes', 
    operator: search.Operator.ANYOF, 
    values: ['custbody2']
});

This will create a filter that only includes system notes if they are about the Field with ID

custbody2

. Please note that the

values

parameter should be an array, even if you are only passing one value. Also, remember that the

name

and

join

parameters are case sensitive, so make sure you are using the correct case. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******