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]