JavaScript: 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 values.

.filter('id', 'in', '(5,6,7)')  // Use `()` for `in` filter
.filter('arraycol', 'cs', '\{"a","b"\}')  // Use `cs` for `contains()`, `\{\}` for array values

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()`

const \{ data, error \} = await supabase
  .from('countries')
  .select()
  .filter('name', 'in', '("Algeria","Japan")')

On a referenced table

const \{ data, error \} = await supabase
  .from('countries')
  .select(`
    name,
    cities!inner (
      name
    )
  `)
  .filter('cities.name', 'eq', 'Bali')