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:
Nuevo comentario
Por favor, ingresa o regístrate para enviar un comentario.