Symptom
In the Ticket's OWL (Object Work List), tickets are not getting sorted in an ascending order as per status number-code.
Environment
SAP CLOUD FOR CUSTOMER.
Reproducing the Issue
- Go to the Service work center.
- Go to the Tickets view and select standard query All Tickets.
- Now select the column name Status and click on Sort Ascending.
You will see the ticket list is not sorted in an ascending order (For example: Ticket with status code as 5 is showing at the top, whereas tickets with the status code as 1 is showing below in the list).
Cause
You have not correctly adapted, how the status based on status code or status description should be sorted.
Resolution
- Go to the Service work center.
- Go to the Tickets view and select standard query All Tickets.
- Go to the Adaptation Mode and select the Ticket List.
- Now, right click on the Status column and then in the Overview section of Adaptation Mode click on Value - Drill Down.
- Further click on Code List - Drill Down, where you have set Display as Code and Value.
- However, for the Sort option you have selected the Ascending Description.
- You need to select sort option as Ascending Code, so that in the Ticket List the tickets will be sorted in ascending order based on the status number - code instead of status description.
- After making the adaptation changes, click on the End Adaptation.
Now, you will see the tickets are getting sorted based on status code (For example: Ticket with status code as 1 is showing at the top, whereas tickets with the status code as 5 is showing below in the list).
Keywords
Ticket Status, Sorting, Ascending Order, Adaptation, Ascending Code, Ascending Description , KBA , LOD-CRM-SRP , Service Request Processing , Problem