Preskoči in pojdi v glavno vsebino

Reporting on linked tickets - Developer & Reporting / DPQL Examples - Deskpro Support

Reporting on linked tickets

Seznam avtorjev

If you'd like to view parent tickets, and the child tickets associated to them you can run the report below:


SELECT tickets.id, tickets.subject

FROM tickets

WHERE tickets.parent_ticket.id <> 0

SPLIT BY tickets.parent_ticket.id, tickets.parent_ticket.subject


This will output a table per parent ticket,  containing all child tickets per the image below:




Uporabno Neuporabno

13 od skupaj 23 oseb je ocenilo to stran kot uporabno.

Dodaj komentar

Pred objavo komentarja se moraš prijaviti.

Potrebuješ namig za geslo?