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]

It appears you are on the right track. I would try going to the variable in your catalog item and adding a variable attribute and sort it by the u_order field you created.

[Jen11]

i did the following and it's still not working: 

[Isaias Souza]

Hi Jen11,

You just need put this reference qualifier variable attribute:
ref_ac_order_by=u_order

[Slava Savitsky]

I think this only works in the autocomplete box, but not in the reference list lookup window.