Deskpro Support

Kontakt

Summing ticket charges - Knowledgebase / Developer & Reporting / DPQL Examples - Deskpro Support

Summing ticket charges

Zadnjič posodobljeno: 14. maj 2018, avtor Benedict Sycamore

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'

Uporabno Neuporabno

48 od skupaj 113 oseb je ocenilo to stran kot uporabno.

Dodaj komentar

Pred objavo komentarja se moraš prijaviti.

Avtor: Ben Henley
Datum vloge: 27. nov. 2015