Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.omni.co/llms.txt

Use this file to discover all available pages before exploring further.

Filters based on multiple conditions. Returns rows that meet at least one of the specified criteria.
Want to create or conditions between multiple columns? Refer to the Filtered measures guide for an example.

​
Syntax

<field_name>:
  or:
    - <filter_operator>: <value>
    - <filter_operator>: <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.
​
or
string
required
The or operator. Contains a list of conditions, of which at least one must be met to be included in results:

​
Examples

Matches dates between January 1-7 and February 1-7, 2025
users.created_at:
  or:
    - between_dates: [ 2025-01-01, 2025-01-07 ]
    - between_dates: [ 2025-02-01, 2025-02-07 ]
Matches California, empty, or null values
users.state:
  or:
    - is: California
    - is: ""              ## "is empty" in the UI
    - is: null            ## "is null" in the UI