Preskoči in pojdi v glavno vsebino

List of tickets that haven't had an agent reply in over 24 hours - Knowledgebase / Developer & Reporting / DPQL Examples - Deskpro Support

List of tickets that haven't had an agent reply in over 24 hours

Seznam avtorjev

Creating a list of tickets that have not had an agent reply in over 24 hours is a good tracking tool.


To generate this list, a report can be created using the DPQL format below:


SELECT tickets.id, tickets.subject, tickets.agent, tickets.status

FROM tickets

WHERE tickets.date_last_agent_reply < (NOW() - INTERVAL 24 HOUR) AND tickets.status = 'awaiting_agent'


The resulting table should look like this:

Uporabno Neuporabno

4 od skupaj 5 oseb je ocenilo to stran kot uporabno.

Dodaj komentar

Pred objavo komentarja se moraš prijaviti.

Potrebuješ namig za geslo?