Support Article

Sorting and filtering work incorrectly with report definition



A repeat grid sourced from a Report Definition with join does not sort / filter correctly on a joined column that is configured to use a link control.

Error Messages

Invalid property reference in log tracer.

Steps to Reproduce

  1. Create section with repeat grid, sourced from report definition with index class join.
  2. Create grid column with link control, that has property reference from index class.
  3. Try to filter values on it, or make a sorting with descending order.

Root Cause

A defect in Pegasystems’ code or rules

The link caption has been configured using a reference to .pxPages(... rather than that standard join syntax JoinPrefix.PropertyNameas shown below, as the standard syntax is not working for links.


This behavior is fixed in later versions of Pega and links work correctly using the standard JoinPrefix.PropertyNamesyntax.

Perform the following local-change:

Use an embedded section to display the link, and configure the additional column settings that are available with sections to specify the join column as property to use to sort / filter.

When an embedded section is used a Sort/filter property can be configured in the columns settings. Specify the join column using the

The embedded contains the link configured using the .pxPages(... syntax.

Published January 30, 2017 - Updated January 31, 2017

Have a question? Get answers now.

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