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

# between

> Filters numeric fields for values within a specified range.

Filters numeric fields for values within a specified range. Returns rows where the field value falls between the minimum and maximum values.

<Tip>
  This filter is **inclusive** of the minimum and maximum values.
</Tip>

## Syntax

```yaml theme={null}
<numeric_field>:
  between: [<min_value>, <max_value>]
```

## Properties

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

<ParamField path="between" type="number[]" required>
  An array with two numeric values. Decimals are supported.

  * `min_value` - The minimum value. Rows with this value will be included in the results.
  * `max_value` - The maximum value. Rows with this value will be included in the results.
</ParamField>

## Examples

```yaml title="Total price is between 10 and 100" theme={null}
orders.total_price:
  between: [10.00, 100.00]
```

```yaml title="Age is not between 18 and 30" theme={null}
users.age:
  between: [18, 30]
```