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

column
REQUIRED
string
The column to filter on
operator
REQUIRED
string
The operator to be negated 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()
  .not('name', 'is', null)

Data source

Response