How to sort the reference lookup list
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2013 10:48 PM
Hello,
How can we sort the reference lookup list (popup window that appears when we click on magnifying glass) alphabetically?
As an example , i have a reference field that references User table, on click of the magnifying glass the pop up that appears i want the list to be sorted alphabetically by' Name'. (Note - i have a reference qualifier on this field)
I read through wiki and it is mentioned that we cannot sort using ORDERBY instead we need to use list controls.
http://wiki.servicenow.com/index.php?title=Reference_Qualifiers#ORDERBY_Condition
I am not sure how to sort reference lookup list using list controls, can anyone please explain?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2013 07:50 AM
In the pop-up window, just click on the header of the column you want to sort on. Optionally you can right-click in the header area of the column you want to sort on and choose (A to Z) or (Z to A).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2013 11:49 AM
An extension of what was said above, you can kind of save the sort after it's been done as shown here: Default Sort on sysapproval_approver
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-11-2013 04:11 AM
Thanks mstoner, that is what i was looking for.