Don't match the filter
Match only rows which doesn't satisfy the filter.
not() expects you to use the raw PostgREST syntax for the filter values.
.not('id', 'in', '(5,6,7)') // Use `()` for `in` filter
.not('arraycol', 'cs', '{"a","b"}') // Use `cs` for `contains()`, `{}` for array values
Parameters
- columnREQUIREDstring
The column to filter on
- operatorREQUIREDstring
The operator to be negated to filter with, following PostgREST syntax
- valueREQUIREDany
The value to filter with, following PostgREST syntax
const { data, error } = await supabase
.from('countries')
.select()
.not('name', 'is', null)