Skip to main content

Summing ticket charges - Knowledgebase / 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, DPQL_ALIAS(CONCAT(FLOOR(tickets.charges.charge_time / 3600), ' Hours ', FLOOR(MOD(SUM(tickets.charges.charge_time), 3600) / 60), ' mins'), 'Charge Time')

FROM tickets


Koristan Beskoristan

54 od 131 ljudi smatralo je ovu stranicu korisnom

Add a comment

Please log in or register to submit a comment.

Need a password reminder?