Range Clauses

Range clauses can be used to select a scalar field whose value falls within a specific range. The math operators =, <, <=, and >= are allowed:

Level > error

LastName <= Q

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

User = [Jane TO Joe}

This is shorthand for:

User >= Jane AND User < Joe

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

User:[Jane TO Joe}

With the Logging service, the Timestamp field can only be queried using a range clause. Example:

Timestamp=['2014-01-01' TO '2014-06-13 12:00']

Note that timestamp literals must be quoted, and time elements can be omitted from right-to-left; omitted elements are considered zero.