Home

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
    string

    The column to filter on

  • operator
    REQUIRED
    string

    The operator to filter with, following PostgREST syntax

  • value
    REQUIRED
    any

    The value to filter with, following PostgREST syntax


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