Question
Common Wealth Bank Of Australia (CBA)
IN
Last activity: 14 Apr 2025 23:50 EDT
Case ID Numeric sorting instead of text sorting
Hi Team,
Can anyone help me how to sort case ID's in numeric format instead of string format
When the filtering option is enabled and the filter icon is clicked, it does a String sort and displays the list as
1 ABC
10 ABC
2 ABC
3 ABC
Is there a way to have numeric sorting instead of String sort so that the filter list is displayed as:
1 ABC
2 ABC
3 ABC
10 ABC
I know PEGA has provided a way here on below link
Inconsistency in the sorting functionality of Work Objects by ID | Pega
I am trying above way but not successful.
Can anyone create the control and function alias rules for above PEGA given approach and provide me the screenshots which will be useful or any other way you sorted the string in numeric way please let me know and attach screenshots
Thanks in Advance
Updated: 14 Apr 2025 23:50 EDT
HCA
US
If the Case ID's are in the format "1 ABC", please follow these steps:
1. Loop through Pagelist containing Case ID properties, and set an integer property (eg : "MySortIndex") within each page using:
@toint(@whatComesBeforeFirst(.CaseID,' '))
2. Perform Obj-Sort on the Pagelist using the new integer property.