Range Operators - Upstash Documentation

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

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"}}'

​Compatibility

​Examples

Compatibility

Examples