Setting choice order for catalog lookup select box

rbertram
Kilo Expert

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

10 REPLIES 10

Mark Stanger
Giga Sage

Attributes don't work on variables. You're stuck with that ordering unless you want to populate the choices manually.


Two+ years later, is this doable in Calgary? I've got a look up select box that I'm using multiple times in a survey. I'd like the values in a specific order, not alphabetical. And I'd hate to put the same variables in over and over and over...one more time...and over


rbertram
Kilo Expert

Mark,

Thanks for confirming what I was fearing. I really have a love/hate relationship with catalog variables...


dcutrano
Giga Contributor

I'm not sure if this is relevant to anyone anymore or if this even provides the solution you're looking for but I was able to script in the sequence by using gp.addOrderby('sequence')