JavaScript: Match the filter

• .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 \{\} for array column and 'cs' for contains.
    .filter('rangecol','cs','(1,2]') // Use Postgres range syntax for range column.
    .filter('id','in','(6,7)')  // Use Postgres list () for in filter.
    .filter('id','in',`($\{arr\})`)  // You can insert a javascript array.
  

Examples

With `select()`

const \{ data, error \} = await supabase
  .from('characters')
  .select('name, book_id')
  .filter('name', 'in', '("Harry","Hermione")')

With `update()`

const \{ data, error \} = await supabase
  .from('countries')
  .update(\{ name: 'Mordor' \})
  .filter('name', 'in', '("Gondor","Rohan")')

With `delete()`

const \{ data, error \} = await supabase
  .from('countries')
  .delete()
  .filter('name', 'in', '("Mordor","The Shire")')

With `rpc()`

// Only valid if the Postgres function returns a table type.
const \{ data, error \} = await supabase
  .rpc('echo_all_countries')
  .filter('name', 'in', '("Mordor","The Shire")')

Filter embedded resources

const \{ data, error \} = await supabase
  .from('instruments')
  .select('name, orchestral_sections ( name )')
  .filter('orchestral_sections.name', 'in', '("strings","woodwinds")')