The MySQL database which stores all your helpdesk data is organised into a series of tables. For example, the tickets table stores information about tickets.

The FROM clause specifies which database table your DPQL query is asking about. You can only pick one table.

All column references in the query must start with the table name specified in the FROM clause.

If you want to retrieve information from multiple tables in a single query, see the section on Cross-referencing table fields for details.

For a list of valid tables, see the DPQL Field Reference section in the appendix.

Published: 16/03/2017

Last updated: 16/03/2017