I have a Lookup Select Box on a variable set on a Catalog item that calls a script include in a reference qualifier and passes in the value of the previous Lookup Select Box into the script include. This script include returns a string value that is the reference qualifier. It works fine in returning the correct values. However, the string includes an 'ORDERBY' value that I cannot get the qualifier to honor.
The u_version_sort_order value is an integer value in the table that is referenced by the Lookup Select Box.
I have tried putting the ORDERBY at the front and end of the string.
I have tried ORDERBYDESC in both cases just to make sure I was not confusing things.
I attempted to not include the ORDERBY at all and instead use the ref_ac_order_by attribute on the select box.
Neither of the options above caused a changed in the order of the available options in the select box.
The 'return' statement in the script include that is called:
return 'sys_idIN' + returnObject + '^ORDERBYu_version_sort_order';EDIT:
The the lookup select box is always ordered ASC by the values returned, which is u_version_name in my table:
I am attempting to get it to order by a u_version_sort_order so that we can account for oddities when strings with alphanumeric values are sorted. In the example below, I intentionally jumbled the version order so that it would be obvious if the lookup select list is sorted or not in testing:
