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?

[verdakosnett]

In attributes for the field: ref_sequence=field_name;

[PrathamjeetS]

How can we do it in descending order?