The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Reference Qualifier - a condition combined with ORDERBY

L_10
Kilo Contributor

‎06-30-2019 05:57 PM

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.

0 Helpfuls
  • 9,410 Views
17 REPLIES 17

Community Alums
Not applicable

‎02-11-2024 09:47 PM - edited ‎02-11-2024 10:03 PM

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

SrushtiJadhav_0-1707717770274.png

 

 
0 Helpfuls

asifnoor
Kilo Patron

‎02-05-2025 09:09 AM - edited ‎02-05-2025 09:09 AM

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.

0 Helpfuls