Reference qualifier help

[Jen11]

Hi,

I am trying to sort a reference field on a catalog item that I have. I need to globally default sort the results of the ref field when they go to the pop up and look at the referenced table.

I have tried a reference qualifier, but that is not working for me. Can anyone suggest what I am doing wrong and how to get it to work. I need to the u_country1 field by the u_order field. The requirement was to have a specific order the u_country1 field items need to be, which is not alphabetical. So I created an Order field that is hidden on the list view, and reference field view to use as the value to use to sort the u_country1 field.

[Daniel Arnold]

^Can confirm - this is the right syntax in the variable attribute field. Just tested it in the PDI.

If it isn't working for you, I'd go back to the field you're sorting on to make sure it's configured correctly.

[Anubhav24]

Hi @Jen11 ,

I found this thread from community ,

https://www.servicenow.com/community/now-platform-forum/sort-in-ascending-for-reference-field/m-p/10...

Let us know if this works for you.

Please mark helpful/correct if my response helped you.

[Slava Savitsky]

There are several settings that have impact on how records are sorted in lists. Detailed information is available in this article. However, users have the possibility to change the sorting at any time. Here is a quote from the documentation:

For any list, if the user has clicked a column header to sort by that column, then that action is remembered. The next time that list is displayed, the same field is used to order the list.

The only way to override user preferences for list sorting is by using sysparm_order URI parameter, but unfortunately you don't have control over URI parameters in a reference lookup window.