- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-29-2024 12:01 PM
I have a Record Producer which has a Variable that is a Lookup Select Box. All the values are stored in the OOTB Choice table (sys_choice). I am trying to make the values sort by the Sequence number in the drop-down box, but it is not working. It seems to be ignoring it, and sort it by alphabetical order, no matter what I do.
First, here are the three entries in the Choice table:
And here is how I have set-up the Variable in the Record Producer:
And here is what I see when I select the drop-down box on the Service Portal:
I also have tried setting the "Variable attributes" property to "ref_auto_completer=AJAXTableCompleter,ref_ac_order_by=sequence" and tried leaving it blank. No matter what I do, the options are always presented in alphabetic order, as shown above.
How do I get it to list these values in Sequence number order on the Service Portal?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-29-2024 12:27 PM
The ref_ac_order_by attribute is used only for the typeahead search on a reference field/variable
In your scenario, you can affect the order of the choices by adding this to the end of your reference qualifier
^ORDERBYsequence
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2024 05:09 AM
Yes, I haven't found or seen a way to change the sort order of list collector results or values - whether they are in the native UI Available/Selected slushbucket view or when using the glide_list attribute or in Service Portal where they appear like List fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-02-2025 08:07 AM
This did not work for me on the Lookup Select Box of sys_choice.
javascript: "element=leave_type^name=sc_req_item^inactive=false^dependent_value="+current.variables.entity_country+"^ORDERBYsequence";
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-09-2025 06:20 AM
Sorry to bring this back up a year later, but seems that this does not completely work. I have set this for 2 fields on my record producer catalog item. When I run this on the portal, it works initially. The form they have me creating is long, about 25 question fields. As I work through testing it, I will go to make a selection on a non-sorted list box, and the form will pause for 2 seconds. After that, if I go back to the fields that I had sorted, they are no longer sorted by sequence, they revert back to sort by label.
