We would like to be able to build reports where you can indicate that the content is based on date range instead of last month or this month as an example.

Comments (1)

Irene Tortorella
Hello Malou, by plugging in dates in the "YYYY-MM-DD" format in the WHERE clause of a raw query, it is possible to include any date range.

Example. Total count of tickets created during the second week of June 2018:

SELECT DPQL_COUNT() AS 'Total Count'
FROM tickets
WHERE tickets.date_created >= '2018-06-04' AND tickets.date_created <= '2018-06-10'

If you have any questions do not hesitate to reach out at support@deskpro.com

Best,

Irene