/build/static/layout/Breadcrumb_cap_w.png

Custom Ticket Sorting in List View

Gerald let me in on a nifty tidbit of information today - there is a simple way to sort tickets in the ticket list view by creating a shortcut with specified ORDER values. The syntax of the URL is as follows:

http://KBOXHOSTNAME/adminui/ticket_list.php?CUSTOM_FILTER=FILTERNAME&ORDER[]=COLUMNNAME1&ORDER[]=COLUMNNAME2...&ORDER[]=COLUMNAMEN

Where all bolded items are going to be dependent upon data from your environment and fields you'd like to sort on. Here is an example I've created to sort by Status, then by Priority, then by Due Date, and then by Impact (NOTE: a space in a filter name is denoted by a (+) plus sign):

http://kbox/adminui/ticket_list.php?CUSTOM_FILTER=Custom+Filter&ORDER[]=STATUS_ORDINAL&ORDER[]=PRIORITY_NUMBER&ORDER[]=sort_DUE_DATE&ORDER[]=IMPACT_ORDINAL

The field names aren't always straight forward, but you can simply click on a column to sort by it and find its name. For example, you can click on Issue to sort by Issue and you'll notice the URL change to something like this:

http://kbox/adminui/ticket_list.php?CUSTOM_FILTER=Custom+Filter&ORDER[]=TITLE

This tells us that the Issue field is named 'TITLE'. You can string as many columns together as you'd like. This neat little trick only works if you use the "UI" trick to view the full path in the KBOX instead of the masked address in the standard console. For those of you who are not familiar with this, simply add 'ui' to the end of your admin console login (i.e. http://kbox/adminui) and you'll see the full path during your session. This also works with the user control panel (i.e. http://kbox/userui instead of http://kbox or http://kbox/user).

0 Comments   [ + ] Show comments

Answers (5)

Posted by: ustacp 14 years ago
Second Degree Blue Belt
0
That is good information, as I did not know about that until about a month ago. We actually use this for users when they login to the user portal. We have multiple help desk queues and have the link saved as you described so that they are automatically placed in the queue that they use the most.
Posted by: chris811 14 years ago
Orange Belt
0
Hello,

how can you setup the trick in order for when the users log in to the self help portal they will be redirected to the filer short cut?

Thank you in advance for your help.
Posted by: airwolf 14 years ago
Red Belt
0
how can you setup the trick in order for when the users log in to the self help portal they will be redirected to the filer short cut?

You can't do a redirect, but you can save the filter as their shortcut to the KBOX.
Posted by: chris811 14 years ago
Orange Belt
0
How can I save the filter as a shorcut?

Thank you.
Posted by: airwolf 14 years ago
Red Belt
0
The same way you create any shortcut in your browser. Go to the filtered page and add a bookmark / favorite.
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