DPQL Field Reference

DPQL Field Reference Tables

This appendix contains a complete list of the available tables and columns, as well as the type of data that each column contains.

Where the datatype of a field is listed as the name of a table in italics, that means the field is used to Cross-referencing table fields to the table.


The table tickets has a field called charges of datatype Ticket Charge.

That means that in a query that is FROM tickets, you can use tickets.charges.* cross-references to retrieve information from the Ticket Charge table.

e.g. to retrieve the charge time for a ticket:


Published: 16/03/2017

Last updated: 31/10/2017