> ## Documentation Index
> Fetch the complete documentation index at: https://upstash.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Range Operators

Range operators filter documents based on numeric or date field boundaries.
You can use them to find values within a range, above a threshold, or below a limit.

| Operator | Description                       | Example        |
| -------- | --------------------------------- | -------------- |
| `$gt`    | Greater than (exclusive)          | `price > 100`  |
| `$gte`   | Greater than or equal (inclusive) | `price >= 100` |
| `$lt`    | Less than (exclusive)             | `price < 200`  |
| `$lte`   | Less than or equal (inclusive)    | `price <= 200` |

You can combine multiple range operators on the same field to create bounded ranges.
For example, `{ $gte: 100, $lte: 200 }` matches values from 100 to 200 inclusive.

For open-ended ranges, use a single operator.
For example, `{ $gt: 500 }` matches all values greater than 500 with no upper limit.

### Compatibility

| Field Type  | Supported |
| ----------- | --------- |
| TEXT        | No        |
| U64/I64/F64 | Yes       |
| DATE        | Yes       |
| BOOL        | No        |
| KEYWORD     | Yes       |
| FACET       | No        |

### Examples

<Tabs>
  <Tab title="TypeScript">
    ```ts theme={"system"}
    // Price range
    await products.query({
      filter: {
        price: { $gte: 100, $lte: 200 },
      },
    });

    // Open-ended range (no upper bound)
    await products.query({
      filter: {
        price: { $gt: 500 },
      },
    });

    // Date range (no lower bound)
    await users.query({
      filter: {
        createdAt: { $lt: "2024-02-01T00:00:00Z" },
      },
    });
    ```
  </Tab>

  <Tab title="Python">
    ```python theme={"system"}
    # Price range
    products.query(filter={"price": {"$gte": 100, "$lte": 200}})

    # Open-ended range (no upper bound)
    products.query(filter={"price": {"$gt": 500}})

    # Date range (no lower bound)
    users.query(filter={"createdAt": {"$lt": "2024-02-01T00:00:00Z"}})
    ```
  </Tab>

  <Tab title="Redis CLI">
    ```bash theme={"system"}
    # Price range
    SEARCH.QUERY products '{"price": {"$gte": 100, "$lte": 200}}'

    # Open-ended range (no upper bound)
    SEARCH.QUERY products '{"price": {"$gt": 500}}'

    # Date range (no lower bound)
    SEARCH.QUERY users '{"createdAt": {"$lt": "2024-02-01T00:00:00Z"}}'
    ```
  </Tab>
</Tabs>