Unresolved ticket broken down by organizations:
SELECT tickets.id, tickets.date_created, tickets.subject
FROM tickets
WHERE tickets.status IN ('awaiting_agent', 'awaiting_user')
SPLIT BY tickets.organization
ORDER BY tickets.date_created ASC
Note we're using SPLIT BY so you can export the ticket list seperately:
Add a comment
Please log in or register to submit a comment.