Summing ticket charges - 知识库 / Developer & Reporting / DPQL Examples - Deskpro Support

Summing ticket charges

最后更新：由 Matthew Wray 于 Mar 6, 2023 更新

If you want to get the sum of all charges on a ticket, you can do this:

SELECT tickets.subject, DPQL_ALIAS(CONCAT(FLOOR(tickets.charges.charge_time / 3600), ' Hours ', FLOOR(MOD(SUM(tickets.charges.charge_time), 3600) / 60), ' mins'), 'Charge Time')

FROM tickets

GROUP BY tickets.id AS 'ID'

有帮助没有帮助

131 人中 54 人认为这个页面有帮助

添加一条评论

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

作者: Ben Henley
创建的日期: Nov 27, 2015