Here’s the list of all the available, operators depending on the data type of the field:
Boolean:
JSON:
- key_null
- key_exists (only key required)
- contains (key and value both required)
Array:
- empty
- contains (elementType required)
Varchar/Text/String:
- starts_with
- ends_with
- blank
- present
- like
- not_like
- is
- not
- contains
- in
Float/Real/Double/Integer:
Date/date-time:
- on
- before
- after
- before_relative
- after_relative
- not
- today
- yesterday
- this_week
- last_week
- this_month
- last_month