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