Reports written against the archive
I need to report on the archive section of the ticketing system
1 Comment
[ + ] Show comment
-
Ok...you'll need to provide more detail than that. - nshah 10 years ago
-
The canned reports that report on the "active" queues are fine. I would like to know if the canned reports can be modified to pull the same type of reports from the archives. - jack.voth 10 years ago
Answers (1)
Please log in to answer
Posted by:
chrisgrim
10 years ago
Jack,
The Archive isn't exposed in the Report Wizard, but you can take any existing ticket report, duplicate it, edit the sql and do the same report against the archive by replacing these five table names in the SQL:
HD_TICKET -> HD_ARCHIVE_TICKET
HD_TICKET_CHANGE -> HD_ARCHIVE_TICKET_CHANGE
HD_TICKET_CHANGE_FIELD -> HD_ARCHIVE_TICKET_CHANGE_FIELD
HD_WORK -> HD_ARCHIVE_WORK
HD_ATTACHMENT -> HD_ARCHIVE_ATTACHMENT
Chris...
