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

Reporting on linked tickets

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:

42 ta' 80 nies li sabu din il-paġna utli

Please log in or register to submit a comment.