Setting choice order for catalog lookup select box
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-20-2012 07:10 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-20-2012 07:42 AM
Attributes don't work on variables. You're stuck with that ordering unless you want to populate the choices manually.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-29-2014 09:29 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-20-2012 11:45 AM
Mark,
Thanks for confirming what I was fearing. I really have a love/hate relationship with catalog variables...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-03-2014 02:11 PM
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')