API Search Call to Filter on Multiple Choice Field Against Multiple Values

API & Customization
1

I have a single value, multiple choice field (for ex, US States) in my table. 

I want to run a query using the API to return all records where the value of this field is any of several states (for ex, Utah, Oregon and Idaho).  Is there an operator to do this?  I thought I could use "is any" and then pass in an array of states as the value, but I believe "is any" simply matches on everything.

"contains" is a substring match ("New" will return any record where the State = "New Jersey", "New York", etc.)

In SQL this would be done with an IN operator:  IN ("Utah","Oregon","Idaho")

Does knack have an equivalent?  The alternative is to run the query once for each state to be matched against using an "is" filter.

2

Hey Mark!

 

You should be able to chain your filter rules with the OR operator. 

 

filters=[{

    match: 'or'

    rules: [{

        field: 'field_123',

        operator: 'is',

        value: 'Utah'

    },{

        match: 'or',

        field: 'field_123',

        operator: 'is',

        value: 'Oregon'

    },{

        match: 'or',

        field: 'field_123',

        operator: 'is',

        value: 'Idaho'

    }]

}]