ServiceNow Not Honoring Sort By Sequence Number

jmiskey
Kilo Sage

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:

jmiskey_0-1730228237294.png

 

And here is how I have set-up the Variable in the Record Producer:

 

jmiskey_1-1730228312440.png

 

And here is what I see when I select the drop-down box on the Service Portal:

jmiskey_3-1730228365276.png

 

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

 

 

1 ACCEPTED SOLUTION

Brad Bowman
Kilo Patron
Kilo Patron

The ref_ac_order_by attribute is used only for the typeahead search on a reference field/variable

https://docs.servicenow.com/bundle/xanadu-platform-administration/page/administer/field-administrati... 

 

In your scenario, you can affect the order of the choices by adding this to the end of your reference qualifier

^ORDERBYsequence

View solution in original post

6 REPLIES 6

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.

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