DPQL Examples
-
How to create a report showing the impact of failed SLAs on Ticket satisfaction
Published: Jul 10, 2018
0Jul 10, 2018 -
Average time till first response
Published: Jul 20, 2021
0Jul 23, 2021 -
Number of tickets created this year month by month compared to last year
Published: Jul 20, 2021
0Jul 23, 2021 -
First Contact Resolution
Published: Jul 20, 2021
0Jul 23, 2021 -
List of tickets that haven't had an agent reply in over 24 hours
Published: Jul 20, 2021
0Jul 23, 2021 -
Average resolution time of tickets
Published: Jul 20, 2021
0Jul 23, 2021 -
Report to generate ticket custom field IDs
Published: Mar 26, 2020
0Mar 26, 2020 -
Reporting on reopened tickets
Published: Jun 27, 2019
0Jul 12, 2019 -
Reporting on linked tickets
Published: Jun 24, 2019
0Jul 12, 2019 -
What do I use in a query to retrieve the email address of ticket users?
Published: Oct 8, 2014
0May 14, 2018 -
Export user data
Published: Nov 1, 2016
0May 22, 2018 -
Number of times 'Downloads' have been downloaded in the user portal
Published: Nov 1, 2016
0May 14, 2018 -
Show tickets in order of the number of different agents who replied
Published: Feb 24, 2016
0May 14, 2018 -
Summing ticket charges
Published: Nov 27, 2015
0Mar 6, 2023 -
Retrieving user hostname information in reports
Published: Jan 30, 2015
0May 14, 2018 -
Can I include Satisfaction survey results in my reports?
Published: Jan 7, 2015
1Sep 2, 2021 -
Displaying ticket messages in a report
Published: Dec 22, 2014
0May 14, 2018