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
2 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
- tweek your report on a single queue
- test and confirm
- make a copy and then adjust the SQL
You will at least then still have the copy to go back to and edit using the wizard if you need to make further tweeks - Hobbsy 9 years ago
To queues for a report, you have two options. First, you can include the queues you want. This will need to be modified for any additional queues created that you want to include:
(HD_TICKET.HD_QUEUE_ID in (1,2,5,9,10))
The other option is to specify the queues to exclude. This will need to be modified for any additional queues created that you want to exclude:
(HD_TICKET.HD_QUEUE_ID not in (3,4,6,7,8)) - grayematter 9 years ago