Preskoči in pojdi v glavno vsebino

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

Summing ticket charges

Seznam avtorjev

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.

Potrebuješ namig za geslo?