You are browsing the documentation for iTop 2.6 which is not the current version.

Consider browsing to iTop 3.1 documentation

OQL Grammar

The OQL grammar can be described as following using the BNF syntax:

query ::= select-query [UNION query]
select-query ::= SELECT class-reference [class-joined] [WHERE expression]
class-reference ::= name [AS name]
class-joined ::= JOIN class-reference ON name.name = name.id
name ::= string | `string`
expression ::=
scalar
| expression operator expression
| (expression)
scalar ::= number | ‘string’ | “string” | column
operator ::= AND | OR | = | <> | != | > | >= | < | <= | LIKE | NOT LIKE | MATCHES
column ::= name | name.name
2_6_0/oql/oql_grammar.txt · Last modified: 2020/02/05 11:42 (external edit)
Back to top
Contact us