I need to report on the archive section of the ticketing system

1 Comment   [ + ] Show Comment

Comments

  • Ok...you'll need to provide more detail than that.
    • 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.
Please log in to comment

Answers

0

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...

Answered 08/02/2013 by: chrisgrim
Senior Purple Belt

Please log in to comment
Answer this question or Comment on this question for clarity