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:
Dodaj komentar
Pred objavo komentarja se moraš prijaviti.