Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Rule alias SORT function not working on Report definition



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

  1. Create a reportDefinition, sorting on a column.
  2. The sorted column should have values starting with both capital letters and lower-case letters.
  3. 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.


Perform the following local-change:

There are 3 work arounds. They are documented in the order of their simplicity.
  1. Configure Upper / Lower case function for the property for which we want to do case insensitive sorting

  1. Populate a top level page by running the report definition and use Obj-Sort activity to perform the case insensitive sorting

  1. Have a Data page bound to the RD and perform Obj-Sort on the post processing activity configuration.



Published April 29, 2016 - Updated October 8, 2020

Was this useful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us