Once you have selected to edit or build a new stat, the stat builder gives you both a guided process, as well as raw DPQL.
DPQL queries consists of a series of clauses:
SELECT select expression
FROM database table
[WHERE conditions]
[SPLIT BY split fields]
[GROUP BY group fields]
[ORDER BY order fields]
[LIMIT amount [OFFSET offset amount]
[LAYER WITH another query]
[IN subquery]
[UNION another subquery]
Clauses in [square brackets] are optional.
Italic text is a placeholder for a value that you enter.**
Note
If you want your query to refer to a particular item (e.g. one of your departments), you will often refer to the item by its ID number.
Please log in or register to submit a comment.