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   [ + ] Show Comments

Comments

Please log in to comment

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.

Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share