Gå til hovedindhold

How can I see which tickets have been resolved by only one agent? - Videnbase / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. Consider upgrading to Deskpro Horizon

How can I see which tickets have been resolved by only one agent?

Forfatterliste

For a number of purposes, you may want to generate a report that shows a list of resolved tickets ordered by the number of agents who have replied or added a note to that ticket.
Simply enter these queries into the query builder when creating a custom report in the reporting interface:

SELECT DPQL_COUNT_DISTINCT(tickets_messages.person) AS 'Number of agents', tickets_messages.ticket_id, tickets_messages.ticket
FROM tickets_messages
WHERE tickets_messages.person.is_agent AND tickets_messages.ticket.status = 'resolved'
GROUP BY tickets_messages.ticket_id
ORDER BY DPQL_COUNT_DISTINCT(tickets_messages.person)


This will generate a report that shows a list of resolved tickets ordered by the number of agents who have replied or added a note to that ticket.
For more information on creating reports, refer to our guide on the Anatomy of a DPQL Query.

Hjælpsom Unyttig information

27 af 62 personer fandt denne side nyttig

Tilføj en kommentar

Log ind, eller opret dig for at skrive en kommentar.

Har du brug for en påmindelse om adgangskode?