/bundles/itninjaweb/img/Breadcrumb_cap_w.png
I am trying to make the owner names in the queue alphabetical inside the ticket view. In mysql workbench I can order them with this SQL statement. 
Select USER.FULL_NAME
From USER_LABEL_JT
JOIN USER ON (USER_LABEL_JT.USER_ID = USER.ID)
Where LABEL_ID = 51
ORDER BY FULL_NAME
The label is Help Desk Associate and my Queue ID is 2. Not sure how to do this in the K1000.
Answer Summary:
Cancel
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

Answers

1

You just need to add ASC or DESC at the end of ORDER BY FULL_NAME. That will show them in alphabetical order by the full name field. 

ORDER BY FULL_NAME ASC

or

 

ORDER BY FULL_NAME DESC

Answered 04/18/2013 by: nshah
Red Belt

  • OK thank you. So when I am in my queue on the K1000 and I open up an existing ticket and expand the owners drop down box, how do I update that list to be alphabetical. Can this be done with a ticket rule?
  • what version server are you as as mine are in order and that is without ticket rules.
  • v5.3.53053 Your ticket owners are in order? I spoke with Kace support and they said the only way to do this is with a ticket rule.
  • yep..they are in order and I am running 5.4.76848 and I don't have any rules or have run any rules to do that in my KBOX.
Please log in to comment
1

Answered 04/18/2013 by: jestes1013
Orange Belt

Please log in to comment
This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.