Match at least one filter
Match only rows which satisfy at least one of the filters.
or() expects you to use the raw PostgREST syntax for the filter names and values.
1.or('id.in.(5,6,7), arraycol.cs.{"a","b"}') // Use `()` for `in` filter, `{}` for array values and `cs` for `contains()`. 2.or('id.in.(5,6,7), arraycol.cd.{"a","b"}') // Use `cd` for `containedBy()`
Parameters
filters
REQUIRED
stringThe filters to use, following PostgREST syntax
options
Optional
objectNamed parameters
foreignTable
Optional
stringDeprecated, use `referencedTable` instead
referencedTable
Optional
stringSet this to filter on referenced tables instead of the parent table
const { data, error } = await supabase
.from('countries')
.select('name')
.or('id.eq.2,name.eq.Algeria')