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.

[Raf1]

Hi L,

Is the variable a lookup select box?

What version is your instance on?

The previous post below should be able to help you:

https://community.servicenow.com/community?id=community_question&sys_id=55a5eb6adb79ab00fb115583ca96...

[L_10]

Hi Raf,

my instance is London.

The url you gave me says the issue occurred in Kingston and Jakarta, but maybe in London as well...?

[Raf1]

Possibly mate, I would suggest raising a HI ticket.

[Omkar Mone]

Hi 

Your call is like this and i see a space between javascript: and the next word. 

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

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

Copy the above bold part which is without space.

Regards,

Omkar Mone.

www.dxsherpa.com

[L_10]

Hi Omkar,

Thank you  for your reply.

I tried your version, and all choices are gone...

And I tried my version without space, choices appear, but order are not organized...

I really do not know what is wrong 😞

Cheers,

Lit