跳到主要内容

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:

有帮助 没有帮助

80 人中 42 人认为这个页面有帮助