Archived status

DPQL Reference

When you create custom reports with the Reports Builder, tickets that have been Ticket archiving will not show up if you query only for resolved tickets.

Archived tickets have a tickets.status value of ‘archived’.

To ensure you match resolved OR archived tickets, you should check for:

WHERE tickets.status IN ('resolved''archived')

There is also a tickets.date_archived field which indicates when the ticket was last archived.

Note that the built-in reports for resolved tickets already include archived tickets.

Published: 16/03/2017

Last updated: 16/03/2017