I'm looking for an executive report that shows all tickets that have been opened in the past 12 months. Currently I have archiving set up for tickets that have been closed over 6 months. I can only seem to report on EITHER the archive OR my service desk, but not a report that will give me a true ticket report from BOTH.

 

Thanks.

1 Comment   [ + ] Show Comment

Comments

  • Because you are pulling from two different tables without a relationship between them I think the best way to accomplish this is with two reports. I messed around a little but and can't figure out a way to pull from both archived and active ticket tables.
    • If both queries have the same columns (number and data type), you can union the two queries into one report. http://dev.mysql.com/doc/refman/5.6/en/union.html
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity