Is it possible to configure a report to view tickets on multiple queues? I'd assume there is, but how does one create a query for that?
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


Yes, it's actually easier than restricting the report to one queue. All tickets are in the HD_TICKET table, regardless of their queue number.

If you want to restrict to a specific queue, you'd use "WHERE HD_TICKET.HD_QUEUE_ID = 1", specifying the appropriate queue ID. For multiple queues, you'd change "= 1" to "in (1,2)". You can add as many elements to the array as you want - comma separating them. For example, 5 queues numbered 1 through 5 would be (1,2,3,4,5).
Answered 12/03/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
The wizard does focus on one queue so if you edit the same report in the SQL editor you should be able to find a reference to HD_TICKET.HD_QUEUE_ID = 1 (as airwolf is referring to ) in your existing report and modify that part. The problem is that once you edit the SQL of the report then you can't go back in the wizard and tweak it, but it should be easy enough to make this modification again.

TIP: if you want to keep your original then duplicate the report before you modify it. Also make sure you click "autogenerate layout" checkbox if you change anything
Answered 12/03/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment