How to sort the reference lookup list

tj2
Kilo Contributor

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

3 REPLIES 3

geoffcox
Giga Guru

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


mstoner
Kilo Contributor

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


tj2
Kilo Contributor

Thanks mstoner, that is what i was looking for.