Help

Equivalent of 'WHERE field in (value1, value2, value3)' with Airtable API

Topic Labels: API
1772 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tangent_Lin
4 - Data Explorer
4 - Data Explorer

Hi I have come across the need of filtering records based on a field’s value in a defined list of values, this is equivalent to SQL WHERE clause like WHERE field IN (value1, value2, value3), so I wonder how I achieve this with Airtable API.

1 Reply 1
openside
10 - Mercury
10 - Mercury

You would use the OR function:

OR(field = value1, field = value2, field = value3 )