Flutter: Match the filter

Match only rows which satisfy the filter. This is an escape hatch - you should use the specific filter methods wherever possible.

.filter() expects you to use the raw PostgREST syntax for the filter names and values, so it should only be used as an escape hatch in case other filters don't work.

.filter('arraycol','cs','{"a","b"}') // Use Postgres array {} and 'cs' for contains.
.filter('rangecol','cs','(1,2]') // Use Postgres range syntax for range column.
.filter('id','in','(6,7)')  // Use Postgres list () and 'in' for in_ filter.
.filter('id','cs','{${mylist.join(',')}}')  // You can insert a Dart array list.

Parameters

• column

  (Required)

  The column to filter on.

• operator

  (Required)

  The operator to filter with, following PostgREST syntax.

• value

  (Required)

  The value to filter with, following PostgREST syntax.

Examples

With select()

final data = await supabase
  .from('characters')
  .select()
  .filter('name', 'in', '("Ron","Dumbledore")')

With update()

final data = await supabase
  .from('instruments')
  .update({ 'name': 'piano' })
  .filter('name', 'in', '("harpsichord","clavichord")');

With delete()

final data = await supabase
  .from('countries')
  .delete()
  .filter('name', 'in', '("Rohan","Mordor")');

With rpc()

// Only valid if the Stored Procedure returns a table type.
final data = await supabase
  .rpc('echo_all_countries')
  .filter('name', 'in', '("Rohan","Mordor")');

On a referenced table

final data = await supabase
  .from('orchestral_sections')
  .select('''
    name,
    instruments!inner (
      name
    )
  ''')
  .filter('characters.name', 'eq', 'flute')