Skip to main content
Filters for inequality. This operator applies to all filter types and matches rows where the field value does not equal the specified value. This is the negated form of is:.

​
Syntax

<field_name>:
  not: <value>

​
Properties

​
field_name
string
required
The field to filter on, specified in the format view_name.field_name. Can be a time, numeric, or string field.
​
not
string | number | date
required
The value to exclude. Type should correspond to the field type (string, number, or date).

​
Examples

Doesn't match inactive
users.status:
  not: inactive
Doesn't match 0
orders.quantity:
  not: 0
Doesn't match January 1, 2024
created_at:
  not: 2024-01-01