Sorting not following Sequence Field

[tstocking]

Anyone experience an issue with a choice list that has a predefined sequence but when trying to sort in list view it does so alphabetically instead?

Choices:

Sort is Alphabetically and not by Sequence:

[ghsrikanth · Accepted solution]

The choice list will be sorted by Value - Section 3.1.1 "Choice list fields are sorted by the value of the field, not by the label for the field."

Finding Information in Lists - ServiceNow Wiki

The sequence is used to display the order in the Choice field, not used for the sorting order

Mark if it is helpful, feedback is appreciated

[tstocking]

Thanks Srikanth.   When would you use Type "Choice" then over Type "Integer" with a specified list of choices?   Since we use an integer in the Value field for both and sorting works correctly.

[ghsrikanth]

Yes, you can use that - but for sorting you still can't expect the sequence to come into play. Sequence is only for displaying the order in the Choice selection.