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' for in_ filter. 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.
final data = await supabase
.from('cities')
.select('name, country_id')
.or('id.eq.20,id.eq.30');