Skip to main content

Summing ticket charges - 지식 베이스 / Developer & Reporting / DPQL Examples - Deskpro Support

Summing ticket charges

Authors list

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

 

SELECT tickets.subject, TIME_FORMAT(SEC_TO_TIME(SUM(tickets.charges.charge_time)), '%Hh %im') AS 'Charge Time'

FROM tickets

GROUP BY tickets.id AS 'ID'

도움이 되었습니다 Unhelpful

45 of 104 people found this page helpful

댓글 등록

Please log in or register to submit a comment.

Need a password reminder?