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('instruments')
  .select('name')
  .or('id.eq.2,name.eq.cello');

Use `or` with `and`

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

Use `or` on referenced tables

final data = await supabase
  .from('orchestral_sections')
  .select('''
    name,
    instruments!inner (
      name
    )
  ''')
  .or('section_id.eq.1,name.eq.guzheng', referencedTable: 'instruments' );