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

Consider browsing to iTop 3.2 documentation

Known issues and limitations

New since 2.3.0: New constrains on OQL formatting due to Request optimization:

If the user has Allowed organizations defined, then this query will fail for him

SELECT l FROM Organization AS child 
JOIN Organization AS root ON child.parent_id BELOW 
JOIN Location AS l ON l.org_id =

Use instead

SELECT Location AS l 
JOIN Organization AS child ON l.org_id = 
JOIN Organization AS root ON child.parent_id BELOW

New in 2.0.1: Negative integers are supported. Hexadecimal numbers are supported.

Negative numbers are not accepted. The workaround is to specify negative values -n as the expression (0 – n).

The operator ! is not accepted.

The equivalent of !ISNULL(start_date) can be expressed ISNULL(start_date) != 1

true and false are not accepted,

  • use 1 instead of true
  • use !=1 instead of false

null is not accepted, use instead the function ISNULL(attribute)


Currently OQL does not support LIMIT, ORDER, GROUPBY, COUNT, SUM, and many other functions
2_4_0/oql/oql_limitations.txt · Last modified: 2018/12/19 11:40 (external edit)
Back to top
Contact us