between

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

This filter is inclusive of the minimum and maximum values.

Syntax

<numeric_field>:
  between: [<min_value>, <max_value>]

numeric_field

string

required

The numeric field to filter on, specified in the format view_name.field_name.

between

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.

Total price is between 10 and 100

orders.total_price:
  between: [10.00, 100.00]

Age is not between 18 and 30

users.age:
  between: [18, 30]