Symptom
- Sorting the Ticket Status column does not produce the expected order.
- Users may notice discrepancies in the sorting behavior, such as numbers appearing out of sequence.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Navigate to the Service work center.
- Access the Ticket view.
- Select the Status column.
- Apply Sort Ascending to the column.
- Observe the sorting behavior, where numbers may appear out of sequence, such as 11 preceding
Cause
The issue arises due to the inherent behavior of alphanumeric sorting, which organizes numbers based on their first numeral rather than their numerical value.
Resolution
- Understand that alphanumeric sorting prioritizes alphabetical order first, followed by numerical order based on the first numeral.
- For example, 1300 will appear before 140 due to the sorting logic.
Keywords
ticket status sorting, alphanumeric sorting, unexpected sorting behavior, SAP Cloud for Customer, service request processing, sorting issue, ticket view, ascending sort, column sorting, sorting discrepancy, alphanumeric order, sorting logic, numerical sorting, sorting anomaly, ticket status order, sorting explanation , KBA , LOD-CRM-SRP , Service Request Processing , Problem
Product
SAP Cloud for Customer core applications all versions
SAP Knowledge Base Article - Public