KACE Product Support

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).