Python: Match the filter

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

  (Optional)

  The operator to filter with, following PostgREST syntax

• value

  (Optional)

  The value to filter with, following PostgREST syntax

Examples

With `select()`

response = (
    supabase.table("countries")
    .select("*")
    .filter("name", "in", '("Algeria","Japan")')
    .execute()
)

On a foreign table

response = (
    supabase.table("countries")
    .select("name, cities!inner(name)")
    .filter("cities.name", "eq", "Bali")
    .execute()
)