Skip to main content

First Contact Resolution - Tudásbázis / Developer & Reporting / DPQL Examples - Deskpro Support

First Contact Resolution

Authors list

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:

Hasznos Nem hasznos

36 felhasználóból 16 hasznosnak találta ezt a cikket.

Kérjük ebbe a mezőbe írja hozzászólását, majd kattintson a 'Hozzászólás beküldése' gombra...

Please log in or register to submit a comment.

Need a password reminder?