Sort Issue with Lookup Select Box Variable

[purdue]

Hello,

I have a requirement to order values on the VDI Pool name variable make application  Windows 11(Win 11) appear at the top of the list.   I have tried multiple ways to do this but nothing works.  I am using the order field on a custom table and have put all 4 order as least value. I tried add order to reference and ref_ac_order_by=u_order   Any suggestions?  Thanks!

[Slava Savitsky · Accepted solution]

Oh, I was under impression you were using a reference variable. For lookup select box variables, choices are sorted by label in alphabetical order. I am not aware of a way to change it. What you could do, however, is make Order part of the label. Then you would have the desired sorting order. Just set Lookup label field(s) to:

u_order,u_application_name // assuming "Application name" field is "u_application_name"

[Slava Savitsky]

I have just tried your initial approach with "^ORDERBYu_order" in the reference qualifier in my PDI and it worked!

[purdue]

Hello,

Still did not work.  

[purdue]

Windows 11 options should be at the top.

[purdue]

Hello,

I reversed the order for windows 11 so it was last in list now it is first.   I will need to check with the ba to see if having the order visible is ok.  Thanks for your help.