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

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.

17 REPLIES 17

Raf1
Tera Guru

Are you able to try:

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

L_10
Kilo Contributor

Thank you, Raf,

 

unfortunately, it did not work...

All the choices no longer appear X( 

 

Try putting the sort on the attribute field

find_real_file.png

and reference qualifier on:

find_real_file.png

L_10
Kilo Contributor

Thank you Raf, 

 

my variable attribute already has the following value.

ref_qual_elements=u_item_name_women

 

So I tried this:

ref_qual_elements=u_item_name_women,ref_ac_order_by=u_order

Still not working...

 

My office may have some weird settings and it may affect some code...

 

If you do not mind and come up with another possible solution, 

I'd be very grateful!

 

Cheers,

Lit