Inconsistency in the sorting functionality of Work Objects by ID
Work objects IDs are sorted as text strings. As a result, sorting by ID in ascending order will list "IN-186454" before "IN-189", for example. This makes it difficult for application users to sort reports in a meaningful way.
Steps to Reproduce
- Log in to the Pega user portal.
- Click the Workbaskets tab.
- Select a workbasket.
- Click the column name Exception ID to sort them.
Work objects IDs are sorted as text strings. As a result, the numeric part of the ID does not determine the sort order (as it should).
There are two rules that have to be defined and implemented into the desired report:
- Define a Function Alias
- Define a Control
Define a Function Alias to return the numeric part of the ID as an integer.
Define a control to add back the prefix of the ID ("E-" in this example).
Use these in the report column instead of the ID property.