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

  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.



Resolution



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.