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.
1.filter('id', 'in', '(5,6,7)') // Use `()` for `in` filter 2.filter('arraycol', 'cs', '{"a","b"}') // Use `cs` for `contains()`, `{}` for array values
Parameters
column
REQUIRED
stringThe column to filter on
operator
REQUIRED
stringThe operator to filter with, following PostgREST syntax
value
REQUIRED
anyThe value to filter with, following PostgREST syntax
const { data, error } = await supabase
.from('countries')
.select()
.filter('name', 'in', '("Algeria","Japan")')