Creating a saved search, I need to filter by `line...
# suitescript
e
Creating a saved search, I need to filter by
lineuniquekey
using an array of IDs.
anyof
doesn't work, so I guess a formula could work but I'm not sure about the syntax Any help would be appreciated
e
lineuniquekey
is an Integer field, which supports the
any
operator.
Untitled.js
e
Thanks Eric, but it doesn't work. It just ignores that filter without error, but doesn't filter the results.
b
the usual choices are a bunch of
OR
operators in a filter expression
or using the in condition in a formula
e
Thanks! It works like this
case when {lineuniquekey} in (36474785, 36474788, ...) then 1 else 0 end
1