Sorting reference field lookup

[andypollino]

Hi. I have a reference field that refers to a table ('u_infra_cost_of_ram') with two columns that I care about: RAM, an Integer field with internal name of 'u_ram', and Price, a Price field with internal name of 'u_price'. I want users in the Service Catalog to go into the reference lookup and see the RAM values sorted, descending. I tried adding '^ORDERBYu_ram' onto my advanced qualifier (set based on other fields in a Client Script) at the very end, per the suggestion at Sort on a catalog reference field , but that did not work for me. I tried using the advice presented in the thread at How to sort the reference lookup list , but that only sorted the view for me (I want all users to have this view).

I tried changing the RAM field to be a string and then implement the suggestions above, but that did not work either. What can I do to show the user of my service catalog a sorted list?

What information can I provide to help elucidate this question?

[Patrick Schult2 · Accepted solution]

That suggestion where you sorted the reference lookup column - the one that only applied to you - is saved as a User Preference, with your name on it. If you want it to apply to all users, you would locate the User Preference from User Administration > User Preferences, clear the "User" field, and tick the "System" checkbox.

[andypollino]

This worked for me. Thank you

[snhoule]

This solution does not work for me on the Service Portal.  It works ok when I try my catalog item in itil view, but from SP the sort order I set as a system preference does not apply

[service buzz]

Hi.

Even I have created the same user preference by clicking on system it is working but it is not working on service portal which will come from record producer from service catalog but that is refering to same table.