This report gives you a list of tickets by brand and associated user infromation:
SELECT tickets.id, tickets.person.name, tickets.person.emails.email
FROM tickets
SPLIT BY tickets.brand.name
Note that as we're using SPLIT BY you can export the ticket lists for each brand seperately:
Add a comment
Please log in or register to submit a comment.