Match at least one filter
Finds all rows satisfying 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.(6,7),arraycol.cs.{"a","b"}') // Use Postgres list () and 'in' instead of `inFilter`. Array {} and 'cs' for contains. 2.or('id.in.(${mylist.join(',')}),arraycol.cs.{${mylistArray.join(',')}}') // You can insert a Dart list for list or array column. 3.or('id.in.(${mylist.join(',')}),rangecol.cs.(${mylistRange.join(',')}]') // You can insert a Dart list for list or range column.
Parameters
filters
REQUIRED
StringThe filters to use, following PostgREST syntax
referencedTable
Optional
StringSet this to filter on referenced tables instead of the parent table
final data = await supabase
.from('cities')
.select('name, country_id')
.or('id.eq.20,id.eq.30');