Reporting on Linked Tickets - 지식 베이스 / Using Deskpro / Reports - Deskpro Support

Reporting on Linked Tickets

If you'd like to view parent tickets and the child tickets associated with 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 linked to it, as per the image below:

이 페이지가 도움이 된다고 생각하는 사람들의 수 42 / 80