Overslaan naar hoofdinhoud

Show tickets in order of the number of different agents who replied - Kennisbank / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. For the most up-to-date version, see: Show Tickets ordered by number of Agents who replied until Resolution

Show tickets in order of the number of different agents who replied

Lijst van auteurs

Question:

How can I create a report to show resolved tickets with only one agent replying to the ticket?

Answer:

This will show resolved tickets ordered by the number of agents who have added replies (or notes).

 

SELECT DPQL_COUNT_DISTINCT(tickets_messages.person) AS 'Number of agents', tickets_messages.ticket_id, tickets_messages.ticketFROM tickets_messagesWHERE tickets_messages.person.is_agent AND tickets_messages.ticket.status = 'resolved'GROUP BY tickets_messages.ticket_idORDER BY DPQL_COUNT_DISTINCT(tickets_messages.person)

Behulpzaam Niet nuttig

50 van 104 mensen vonden deze pagina nuttig

Reactie toevoegen

Log in of registreer om een reactie te plaatsen.

Heeft u een wachtwoordherinnering nodig?