Preskoči in pojdi v glavno vsebino

Summing ticket charges - 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

15 od skupaj 28 oseb je ocenilo to stran kot uporabno.

Dodaj komentar

Pred objavo komentarja se moraš prijaviti.

Potrebuješ namig za geslo?