This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

trying to search a text field using an array of possible values, but am getting some errors.  SS2.0:
`filters: [["myfield", "any", ["hello", "world"]]` didn't work, neither did
`filters: [["myfield", "anyof", ["hello", "world"]]` or
`filters: [["myfield", "contains", ["hello", "world"]]`

filters: [["myfield", "anyof", ["hello", "world"]] should work nicely for you and would save you the mess of writing a formula and then putting in logic to get the values based on that formula.

Can you share the error you got.

BTW, It should be filters: [["myfield", "anyof", "hello", "world"]]
i.e. hello and world need not be an array.