I'm trying to write a search in a SuiteScript (2.0) to find things in a list of values. It happens to be an

inventorynumbers

search, where I have a list of inventory numbers, and I'm searching to find their IDs, but the question itself is very general: How can i filter on a list of values? I tried

['inventorynumber', 'anyof', ['SN1', 'SN2']]

but it gives me

UNEXPECTED_ERROR

. Any ideas?

wrong type of filter

i thought

is

could only work on one value?

a somewhat slower alternative is a formula using the in operator in a formula:

[
  "formulanumeric: CASE WHEN {inventorynumber} IN ('SN1', 'SN1') THEN 1 ELSE 0 END",
  "equalto",
  "1",
]

ah ok i figured there must be a way to do it with a formula. But you recommend the OR syntax over the formula? Either way ill have to modify the array (I did confirm that IS only finds the first value)

different types of columns support different types of operators

Oh wow thanks! I've never seen this page before. So basically since this is a text value I can only use the operators in the text column, and anyof isnt one of them huh :(( ok I will try one of these solutions though thank you so much!

Also there is nothing wrong with having to write a function to dynamically add filters with `OR`'s, it's a good thing to get used to when doing more complicated searches. Also the

OR

method may be faster the larger the dataset gets, formula's in criteria slow the search down.

Thanks, I'm going to try the

OR

way 🙂