does anyone know if its possible to do a search wh...
# suitescript
n
does anyone know if its possible to do a search where there is an array of values in a saved search filter like below *but the field is a text field (*so usually it would be "is" or "contains", etc.)
Copy code
var lineItemSearch = search.create({
            type: 'transaction',
            filters: [
              ['custcol_sf_order_line_id', 'is', [
                "802Am000000jGt6IAE",
                "802Am000000jGt7IAE"
             ]]
            ],
            columns: [
              search.createColumn({
                name: 'custcol_sf_order_line_id',
                summary: 'GROUP'
              }),
              search.createColumn({
                name: 'amount',
                summary: 'SUM'
              })
            ]
          });
a
I think you just have to have separate filters for each and
OR
them.
b
secondary option is a formula which uses the IN condition
👍 1
n
@Anthony OConnor that's what I ended up doign
works like a charm
👍 1