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
‎10-21-2024 02:06 AM
This worked for me but I still needed to complete the variable attribute as well
Here is my solution:
ORDERBYsequence^name=replaceWithYourTableName^element=replaceWithElementName^inactive=false
ref_ac_order_by=sequence