Deskpro Support

Kontakt

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

Summing ticket charges

Zadnjič posodobljeno: May 14, 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

54 od skupaj 131 oseb je ocenilo to stran kot uporabno.

Dodaj komentar

Pred objavo komentarja se moraš prijaviti.

Avtor: Ben Henley
Datum vloge: Nov 27, 2015