Dart Reference v2.0

Don't match the filter

Finds all rows which doesn't satisfy the filter.

  • .not() expects you to use the raw PostgREST syntax for the filter names and values.

    1.not('name','eq','Paris')
    2.not('arraycol','cs','{"a","b"}') // Use Postgres array {} for array column and 'cs' for contains.
    3.not('rangecol','cs','(1,2]') // Use Postgres range syntax for range column.
    4.not('id','in','(6,7)')  // Use Postgres list () and 'in' instead of `inFilter`.
    5.not('id','in','(${mylist.join(',')})')  // You can insert a Dart list array.
Parameters
    column
    REQUIRED
    String

    The column to filter on.

    operator
    REQUIRED
    String

    The operator to be negated to filter with, following PostgREST syntax.

    value
    Optional
    Object

    The value to filter with, following PostgREST syntax.


final data = await supabase
  .from('cities')
  .select('name, country_id')
  .not('name', 'eq', 'Paris');