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.
![](https://support.deskpro.com/file.php/3777AWGAQYKCTX377687124E015/1552991926818.png)
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
Ny kommentar
Logg på for å registrere eller sende inn en kommentar.