Passer au contenu principal

How can I specify a sub-status in stats? - Base de connaissances / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. For the most up-to-date version, see: How can I specify a Sub-status in Stats?

How can I specify a sub-status in stats?

Liste des auteurs

You can specify sub-statuses in the WHERE clause like so:

WHERE tickets.ticket_status.id = 4

The sub-status ID can be retrieved using the API or by going to Admin > Tickets > Statuses and clicking on the Sub-status. The ID will appear in the URL bar.



Below is an example:

SELECT tickets.id, tickets.subject, tickets.ticket_status.title

FROM tickets

WHERE tickets.ticket_status.id = 3


We have used tickets.ticket_status.title in the SELECT clause to display the correct sub-status name

Utile Peu Utile

30 personnes sur 74 ont trouvé cette page utile

Ajouter un commentaire

Veuillez vous connecter ou vous enregistrer pour soumettre un commentaire.

Besoin d'un rappel de mot de passe?