Gå till huvudinnehåll

Show tickets in order of the number of different agents who replied - Kunskapsbas / 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

Författarlista

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)

Hjälpfull Oanvändbar

50 av 104 personer tyckte att sidan var användbar

Posta en kommentar

Logga in eller registrera dig för att lämna en kommentar.

Behöver du en påminnelse om ditt lösenord?