Reference Qualifier - a condition combined with ORDERBY

[L_10]

Hi Community,

I have a question about how to write reference qualifier.

I have a condition to filter a select lookup box, and I want to organize the choices using ORDERBY.

Now my reference qualifier is like this:

javascript: 'u_item_name='+current.variables.u_item_name_women;

And I want to add ORDERBY, however, it didn't work after trying the below ones:

javascript: 'u_item_name='+current.variables.u_item_name_women^'ref_ac_order_by='u_order;
javascript: 'u_item_name='+current.variables.u_item_name_women+'^ref_ac_order_by=u_order';
javascript: 'u_item_name='+current.variables.u_item_name_women^ORDERBYu_order;

I suspect the codes are slightly wrong, but not knowing which part.

I'd be very thankful if anyone could help me.

[Community Alums]

Hello @L_10 ,

You can add  javascript : 'u_item_name='+current.variables.u_item_name_women^EQ in Reference qualifier and add  ref_ac_order_by=u_order in variable attributes

[asifnoor]

In the variable attributes, ref_ac_order_by=order will sort the data by order column. I have just tested in Xanadu version and it is working correctly. If you do not provide any order, it will by default sort by display name in asc order.

[RohanGladman]

This worked for me!
How to sort the dropdown list for a reference field - Support and Troubleshooting