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

53 od skupaj 130 oseb je ocenilo to stran kot uporabno.

Dodaj komentar

Pred objavo komentarja se moraš prijaviti.

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