I've written a custom report in DPQL. When I run it, it just returns the names of the fields I want, not the actual results. What's going on?
This error is often caused by putting the variable names in quote marks. You don't need to put variables in quotes when writing DPQL.
Another possible cause is forgetting to specify the table as well as the field name:
SELECT date_created, id
You need to specify the table you are selecting from in your query, not just the field:
SELECT tickets.date_created, tickets.id