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
The column to filter on
The operator to filter with, following PostgREST syntax
The value to filter with, following PostgREST syntax
const \{ data, error \} = await supabase
.from('countries')
.select()
.filter('name', 'in', '("Algeria","Japan")')
const \{ data, error \} = await supabase
.from('countries')
.select(`
name,
cities!inner (
name
)
`)
.filter('cities.name', 'eq', 'Bali')