Sorting and filtering does not work on a concatenated column
SummarySorting and filtering does not work in repeat grids on a concatenated column from a report definition.
Error MessagesNot 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 CauseA 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.
ResolutionPerform 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