K1000 SQL Code to Order Owner Names Alphabetically
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.