Setting choice order for catalog lookup select box

[rbertram]

I am having troubles getting the sequence order to work for a catalog Lookup Select Box. The choice list is being displayed in alphabetical order even thugh I added the ref_sequence attribute to the variable. Am I missing something or does the ref_sequence attribute not work for catalog variables?

Variable settings:

Lookup from table: Choice [sys_choice]
Lookup value filed: Value
Lookup label field(s): label
Reference qual: name=change_request^element=reason^inactive=false
Include none: true
Attributes: ref_sequence=sequence

[matthew_magee1]

i think I solved this by adding an order column on the reference table. I'll duplicate it on our POV instance and send screenshots. Stand by

[kaireidegeld]

One additional thing needs to be made to order the contents of lookup select boxes:

If you have a reference table with an order column (e.g. "myordercolumn"), then add "ORDERBYmyordercolumn" to the reference qualifier of the catalog variable.

So Richards qualifier would look like: "ORDERBYmyordercolumn^name=change_request^element=reason^inactive=false"

[kaireidegeld]

You do not need the variable attribute.

Changing the reference qualifier to "ORDERBYsequence^name=change_request^element=reason^inactive=false" will do the trick.

[DaSmith9]

Confirmed, adding the ORDERBYsequence into the ref qualifier statement returns the list sorted to the lookup select box choice list, validated in Tokyo version. (where 'sequence' is the field from the 'sys_choice' table you are ordering by)

[aryanxrai]

Its not happening