Support Article

Sorting and filtering does not work on a concatenated column



Sorting and filtering does not work in repeat grids on a concatenated column from a report definition.

Error Messages

Not Applicable

Steps to Reproduce

  1. Create a report definition and use a concatenate function on one of the columns
  2. Create a section with repeat grd and use the report definition as the data source
  3. Reference the concatenated column from the report in the grid
  4. Enable sorting and filtering using column properties

Root Cause

A defect in Pegasystems’ code or rules. In the pzGridSortPaginate activity, while comparing sortProperty and pyFieldName, the sort property does not have double quotes around the delimiter.


Perform the following local-change:

Instead of passing a string to the SQL function in the report, replace it with a parameter.

Published April 27, 2017 - Updated May 5, 2017

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.