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

Consider browsing to iTop 3.1 documentation

Running Object Queries

iTop uses its own internal query language to retrieve the objects from the database. Inside the MySQL database the objects manipulated by iTop are stored using several relational tables, but the Object Query Language (OQL) hides this complexity by manipulating objects almost as if they were plain SQL tables.

The OQL syntax is quite similar to the SQL syntax, except that there is no need to indicate which columns to retrieve, since iTop always manipulates “objects” and retrieves the columns as necessary.

The menu “Run Queries” allows Administrators to test and run OQL queries (For more information about the OQL syntax, refer to Object Query Language Reference). Some predefined queries are listed as examples at the top of the page (click on “Query Examples” at the top).

Run Queries

To test a query, type the OQL expression in the text area, and click on “Evaluate” to get the results.

Since the result of the query is displayed as an HTML table, only objects that can be displayed as HTML can be queried by this method. The display of a list of internal iTop objects may cause an error when queried this way.
2_7_0/admin/objects_queries.txt · Last modified: 2020/04/15 15:23 (external edit)
Back to top
Contact us