Passer au contenu principal

Unresolved tickets by organization - Remarques / DPQL Reports - Deskpro Support

19

Unresolved tickets by organization Report

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:




Ajouter un commentaire

Veuillez vous connecter ou vous enregistrer pour soumettre un commentaire.

Besoin d'un rappel de mot de passe?