跳到主要内容

List of tickets that haven't had an agent reply in over 24 hours - 知识库 / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. For the most up-to-date version, see: List of tickets with no agent reply in over 24 hours

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

作者列表

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:

有帮助 没有帮助

6 人中 5 人认为这个页面有帮助

添加一条评论

请登录或注册以提交评论。

是否需要密码提醒?