Skip to main content

Supported Data Types and Operators

1. TIME​

For timestamp and date-based values

  • BETWEEN: Selects values between two timestamps
  • EQUALS: =
  • NOT EQUALS: !=
  • LESS THAN: <
  • GREATER THAN: >
  • IS NULL: Checks if the value is null
  • IS NOT NULL: Checks if the value is not null

2. NUMBER​

For numerical values

  • Same as TIME

3. STRING​

For text-based fields

  • CONTAINS, REGEX, IS EMPTY, IS NOT EMPTY

4. BOOLEAN​

True/false values

5. JSON​

For structured, hierarchical data

6. ARRAY​

Array checks (HAS ANY, OVERLAP, ALL, etc.)

7. Logical Operators​

AND, OR, ()