Range Clauses (OLAP)

[Table of Contents](https://github.com/dell-oss/Doradus/wiki/OLAP Databases: Table-of-Contents) | Previous | Next
Doradus Query Language: Range Clauses

---

Range clauses can be used to select a scalar field whose value falls within a specific range. (Range clauses are not allowed on link fields or the `_ID` field.) The math operators `=`, `<`, `<=`, and `>=` are allowed for numeric fields:

Size > 10000
LastName <= Q

Doradus also allows bracketed ranges with both inclusive ([]) and exclusive ({ }) bounds. For example:

Size = [1000 TO 50000}

This is shorthand for:

Size >= 1000 AND Size < 50000

Text fields can also use bracketed range clauses:

FirstName={Anne TO Fred]

This clause selects all objects whose FirstName is greater than but not equal Ann and less than or equal to Fred.

For range clauses, ":" and "=" are identical – both perform an equals search. Hence, the previous example is the same as:

FirstName:{Anne TO Fred]