> ## 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.

# or

> Creates a filter where at least one condition must be met.

Filters based on multiple conditions. Returns rows that meet at least one of the specified criteria.

<Tip>
  Want to create `or` conditions between multiple columns? Refer to the [Filtered measures guide](/modeling/measures) for an example.
</Tip>

## Syntax

```yaml theme={null}
<field_name>:
  or:
    - <filter_operator>: <value>
    - <filter_operator>: <value>
```

## Properties

<ParamField path="field_name" type="string" required>
  The field to filter on, specified in the format `view_name.field_name`. Can be a time, numeric, or string field.
</ParamField>

<ParamField path="or" type="string" required>
  The `or` operator. Contains a list of conditions, of which at least one must be met to be included in results:

  <Expandable title="conditions" defaultOpen="true">
    <ParamField path="filter_operator" type="string" required>
      A filter operator such as [`before`](/modeling/filters/operators/before), [`greater_than`](/modeling/filters/operators/greater-than), etc. and its corresponding value.
    </ParamField>
  </Expandable>
</ParamField>

## Examples

```yaml title="Matches dates between January 1-7 and February 1-7, 2025" theme={null}
users.created_at:
  or:
    - between_dates: [ 2025-01-01, 2025-01-07 ]
    - between_dates: [ 2025-02-01, 2025-02-07 ]
```

```yaml title="Matches California, empty, or null values" theme={null}
users.state:
  or:
    - is: California
    - is: ""              ## "is empty" in the UI
    - is: null            ## "is null" in the UI
```