First Contact Resolution - Knowledgebase / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. For the most up-to-date version, see: First Contact Resolution

First Contact Resolution

Creating a list of tickets that were resolved with only 1 agent reply can be created in the following DPQL format:

SELECT tickets.id, tickets.subject, tickets.agent, tickets.date_created

FROM tickets

WHERE tickets.count_agent_replies = 1 AND tickets.status = 'resolved'

ORDER BY tickets.date_created

The resulting table will be displayed as shown below:

Roedd 18 o 38 o bobl yn teimlo bod y dudalen hon yn ddefnyddiol

Mewngofnodwch neu cofrestrwch i gyflwyno sylw.