- 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";