Reference qualifier "ORDERBY" and javascript does not work

[Shuhei2]

I set a value "ORDERBYu_order^javascript:'u_language='+gs.getSession().getLanguage()" in a Lookup Select Box variable.

Target custome field has fields, u_order and u_language.

I'd like to let users see only the choices filtered by their Language, and sorted by order.

Now users can see all records sorted by u_order in the target table.

Please help me.

Best regards.

[Allen Andreas]

Hi,

Can you try:

javascript:"u_language="+gs.getSession().getLanguage()^ORDERBYu_order;

or perhaps:

javascript:"u_language="+gs.getSession().getLanguage()+"^ORDERBYu_order";

The purpose of rearranging what you had slightly, is to see if the javascript needed to be in front and then proceed.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Dylan Mann1]

Try adding this as an attribute for your reference field:

ref_ac_order_by=u_order

You may need to be showing the order field in your drop down. Let me know if this helps!

[Michael Jones - · Accepted solution]

I think Allen A was on the right track, but I would go with: 

javascript: 'ORDERBYu_order^u_language='+gs.getSession().getLanguage();

You need to make sure that all of the qualifier is within the quotes and that you are appending with the results of your expression. 

If this was helpful or correct, please be kind and remember to click appropriately!

Michael Jones - Proud member of the CloudPires team!

[Allen Andreas]

Thanks. I guess we'll see. I tested my suggestion in my PDI and it seemed to work, then again I only have one language on it, so we'll see. No errors or anything popped up and it seemed in order.