Skip to main content

How can I specify a sub-status in stats? - Kiến thức cơ bản / Developer & Reporting / Creating Reports - Deskpro Support

How can I specify a sub-status in stats?

Authors list

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


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.subject, tickets.ticket_status.title

FROM tickets


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

Hữu ích Unhelpful

30 of 74 people found this page helpful

Thêm nhận xét

Please log in or register to submit a comment.

Need a password reminder?