Support Article
Rule alias SORT function not working on Report definition
SA-22686
Summary
Sorting of a column on ReportDefinition seems to be case-sensitive.
Users are populating an Autocomplete through Report-Definition. When searched for the results in the autocomplete the results are not case-insensitively sorted.
Error Messages
Not Applicable
Steps to Reproduce
- Create a reportDefinition, sorting on a column.
- The sorted column should have values starting with both capital letters and lower-case letters.
- Populate an autocomplete with ReportDefinition as source.
Root Cause
A defect in Pegasystems’ code or rules. The reportdefinition sorting will sort the values starting with capital letters first and then followed by the sorted values which start with small letters.
Resolution
Perform the following local-change:
There are 3 work arounds. They are documented in the order of their simplicity.
- Configure Upper / Lower case function for the property for which we want to do case insensitive sorting
- Populate a top level page by running the report definition and use Obj-Sort activity to perform the case insensitive sorting
- Have a Data page bound to the RD and perform Obj-Sort on the post processing activity configuration.
Result:
Published April 29, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.