All Ticket Queues Category for Reporting
Hello. If I have multiple Ticket Queues (referred to Category in Reporting), how can I run a report to include all Ticket Queues or only selected ones? Currently the Category only allows me to select one. Thanks.
you can, but not via wizard. You can create a report with the wizard and need to change it later as SQL.
So to give you a bit more detail than the last “helpful” response….
create the report, set it up with a single queue, then save the report.
Next take a copy of the report and choose to view the SQL.
in the WHERE statement you should find something like
HD_TICKET.HD_QUEUE_ID = X
that is the line that restricts the report to a single Queue, remove it from the report and you can save it. It will then run on every queue.