Support Article
Sorting and filtering does not work on a concatenated column
SA-37180
Summary
Sorting and filtering does not work in repeat grids on a concatenated column from a report definition.
Error Messages
Not Applicable
Steps to Reproduce
- Create a report definition and use a concatenate function on one of the columns
- Create a section with repeat grd and use the report definition as the data source
- Reference the concatenated column from the report in the grid
- 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.
Resolution
Perform the following local-change:
Instead of passing a string to the SQL function in the report, replace it with a parameter.
Published May 6, 2017 - 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.