/build/static/layout/Breadcrumb_cap_w.png

Unassigned in All Queues .. almost

Hi all

This is a 'nearly there but' in case anyone knows

When we had one queue I'd list Unassigned tickets like so
http://sk01.servisair.com/adminui/ticket_list.php?OWNER_ID=0
to get the new work for assigning to the team

Now, I've added a queue for another section, plus a Deleted Items 'queue'. I need a morning overview of unassigned tickets globally
http://sk01.servisair.com/adminui/ticket_list.php?QUEUE_ID=ALL&OWNER_ID=0
gives me all the unassigned across the queues, great so far. But what I really want is for it to say something like QUEUE_ID=(all but 3) if that's possible

Is there a good reason why Custom View and Advanced Search don't have an option to specify the queue?

Cheers for any shared experience as ever :)

0 Comments   [ + ] Show comments

Answers (5)

Posted by: steelc 12 years ago
Senior Yellow Belt
0
I haven't seen a way to do that with custom views or advanced search, but you could accomplish that with a report. If you used a report then you could even have it emailed to you first thing in the morning and it would be waiting for you when you get in.

The only other way I could think to get around this would be to set the Deleted Items queue to have a custom field with a specific default value. You could then search for tickets that don't have that value and they should get filtered out from the view.
Posted by: Acedashdog 12 years ago
Purple Belt
0
A report won't cut it; I list Mailed In about once an hour... :)
Your idea of a ticket rule to add a value to DI has some legs though! I'll give that a try. Actually, I can probably expand on that... a ticket rule on each queue, on save, to update a field QUEUE with the queue name, will fill this gap of there not being a queryable field for the Queue in the system..

goes off in a brown study
Posted by: Acedashdog 12 years ago
Purple Belt
0
Mmmn, as a workaround, browser toolbar buttons with

http://sk01.servisair.com/adminui/ticket_list.php?CUSTOM_FILTER=Mailed+In&QUEUE_ID=1
http://sk01.servisair.com/adminui/ticket_list.php?CUSTOM_FILTER=Mailed+In&QUEUE_ID=4

do a pretty good job...
Posted by: GillySpy 12 years ago
7th Degree Black Belt
0
We use a bookmarklet which is just some javascript. The only custom part of this is the button near advanced search that initiates it. it could be popped up from your toolbar by embedding javascript into a bookmark.

see attachment.

Comments:
  • here is that bookmarklet http://jsfiddle.net/gillyspy/jbXcY/ click cancel and you'll see it. click "tidy up" to take it out of bookmarklet form for editing. You'll probaby want to change the k1000 URL and the queue specific names e.g. "emea" is probably not relevant to you - GillySpy 10 years ago
Posted by: horstj 11 years ago
Brown Belt
0

I know this is a somewhat old post, but I thought I would share. I have found out that when you create a custom ticket view you can change the URL to search for whatever you want. All you need to do is create a new view and hit test view and then you can edit the URL if you know the column names in the ticket table (you can find them by using mySQL workbench or a similar DB utility). 

 

So in your case Acedashdog, you would pull up the ticket view that you said shows all of the queues.

Then you would need to click the Custom View button and it will auto fill the custom view parameters.

Then just add a new line with AND, (anything here, but we will say Ticket ID), !=, 3.

Click Test View.

Now, in the URL find where it says something like WFIELD5%5D=HD_TICKET.ID&FINDFIELDS which will be closer to the end of the string since we tacked that extra search criteria on as the last one.

Change the HD_TICKET.ID (or whatever collumn you used above) to HD_TICKET.HD_QUEUE_ID.

Press Enter with the URL highlighted and do not hit test view.

You should now have the custom view only showing those tickets not in queue 3.

 

You can change that value in the URL to whatever you want in the HD_TICKET table. You can also edit any of the other items in the search if you scower the URL long enough.

This worked for me and I just wanted to share in case it could help anyone else!

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ