DPQL Examples
-
How to create a report showing the impact of failed SLAs on Ticket satisfaction
Published: 10 de jul. de 2018
010 de jul. de 2018 -
Average time till first response
Published: 20 de jul. de 2021
023 de jul. de 2021 -
Number of tickets created this year month by month compared to last year
Published: 20 de jul. de 2021
023 de jul. de 2021 -
First Contact Resolution
Published: 20 de jul. de 2021
023 de jul. de 2021 -
List of tickets that haven't had an agent reply in over 24 hours
Published: 20 de jul. de 2021
023 de jul. de 2021 -
Average resolution time of tickets
Published: 20 de jul. de 2021
023 de jul. de 2021 -
Report to generate ticket custom field IDs
Published: 26 de mar. de 2020
026 de mar. de 2020 -
Reporting on reopened tickets
Published: 27 de jun. de 2019
012 de jul. de 2019 -
Reporting on linked tickets
Published: 24 de jun. de 2019
012 de jul. de 2019 -
What do I use in a query to retrieve the email address of ticket users?
Published: 8 de out. de 2014
014 de mai. de 2018 -
Export user data
Published: 1 de nov. de 2016
022 de mai. de 2018 -
Number of times 'Downloads' have been downloaded in the user portal
Published: 1 de nov. de 2016
014 de mai. de 2018 -
Show tickets in order of the number of different agents who replied
Published: 24 de fev. de 2016
014 de mai. de 2018 -
Summing ticket charges
Published: 27 de nov. de 2015
014 de mai. de 2018 -
Retrieving user hostname information in reports
Published: 30 de jan. de 2015
014 de mai. de 2018 -
Can I include Satisfaction survey results in my reports?
Published: 7 de jan. de 2015
12 de set. de 2021 -
Displaying ticket messages in a report
Published: 22 de dez. de 2014
014 de mai. de 2018