K1000 Service Desk reports for more than one queue
I'm trying to use the report wizard (I know very little about SQL) to write a few simple reports. We have 5 separate queues (Phones, Software, Network, Equipment Requests, and Facilities).
So, I would like to have a report that shows all of the tickets that have been open for more than 3 days broken up by queue. I can accomplish this very easily for a specific queue by selecting the name of a queue for the topic. However, when I select K1000 Service Desk as the topic - I assumed this was for all of the Service Desks since the other options were each of the individual service desks - I get "No Results" when I run the report.
I have found a workaround but I don't like it. I can go into the SQL and edit where it says (HD_TICKET.HD_QUEUE_ID = 5) and change it to (HD_TICKET.HD_QUEUE_ID > 0)
The problem with this is that once I edit the SQL I can no longer use the wizard to make tweeks to the report.
On a related note, If I do indeed need to edit the SQL in order to make it work, ideally I would like to NOT include the QUEUE with the ID of 8.
Any help would be greatly appreciated
Please log in to answer
Be the first to answer this question