Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

7 REPLIES 7

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

 

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.