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 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 |
{ $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
TypeScript
Python
Redis CLI
// 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" },
},
});
# 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"}})
# 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"}}'
