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]

"ref_ac_order_by" variable attribute should work. Remove "^ORDERBY=u_order" part from your reference qualifier and try again.

[purdue]

Hello,

Thanks for the reply.  This did not work.

[Slava Savitsky]

"ref_ac_order_by" variable attribute only controls the sorting order in the autocomplete box displayed underneath the reference field when you type something in that field, but not in the reference lookup list that is displayed in the popup window when you click on the magnifier icon.

Sorting order in lists depends on several factors. Refer to this article from the product documentation for detailed information. In a nutshell, as an admin, you can preconfigure the default sorting order for a table, but users will be able to change it and their selection will be stored as a user preference and applied automatically the next time they view the same table. So you cannot really control it.

[purdue]

Hello,

Thanks for the response.   So there is no way to sort a select box variable?   This is so crazy that SN won't support this.