Flutter: 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.

  .or('id.in.(6,7),arraycol.cs.\{"a","b"\}')  // Use Postgres list () and 'in' instead of `inFilter`. Array \{\} and 'cs' for contains.
  .or('id.in.($\{mylist.join(',')\}),arraycol.cs.\{$\{mylistArray.join(',')\}\}')	// You can insert a Dart list for list or array column.
  .or('id.in.($\{mylist.join(',')\}),rangecol.cs.($\{mylistRange.join(',')\}]')	// You can insert a Dart list for list or range column.
  

Parameters

• filters

  (Required)

  The filters to use, following PostgREST syntax

• referencedTable

  (Optional)

  Set this to filter on referenced tables instead of the parent table

Examples

With `select()`

final data = await supabase
  .from('countries')
  .select('name')
  .or('id.eq.2,name.eq.Algeria');

Use `or` with `and`

final data = await supabase
  .from('countries')
  .select('name')
  .or('id.gt.3,and(id.eq.1,name.eq.Afghanistan)');

Use `or` on referenced tables

final data = await supabase
  .from('countries')
  .select('''
    name,
    cities!inner (
      name
    )
  ''')
  .or('country_id.eq.1,name.eq.Beijing', referencedTable: 'cities' );