Reference Qualifier - a condition combined with ORDERBY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2019 06:04 PM
Are you able to try:
javascript: 'u_item_name='+current.variables.u_item_name_womenORDERBYu_order;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2019 06:21 PM
Thank you, Raf,
unfortunately, it did not work...
All the choices no longer appear X(

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2019 06:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2019 07:12 PM
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