Pasar al contenido principal

Tickets Closed with One Response - DPQL Reports - Deskpro Support

If you would like to report which tickets have been closed with one message from the agent you can use the DPQL below:

SELECT tickets_messages.ticket.id, tickets_messages.ticket.subject
FROM tickets_messages
WHERE tickets_messages.ticket.count_agent_replies = '1' AND tickets_messages.person.is_agent = 1 AND tickets_messages.date_created = %LAST_WEEK% AND tickets_messages.is_agent_note = 0
SPLIT BY tickets_messages.person
ORDER BY tickets_messages.date_created 

This will split the results out by each agent and show details for each ticket that was quickly resolved by the agent. 

Nuevo comentario

Por favor, inicia sesión o regístrate para enviar un comentario.

¿Necesitas que te recordemos la contraseña?