Support Article

Sorting and filtering work incorrectly with report definition

SA-33035

Summary



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.



Resolution



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
JoinPrefix.PropertyNamesyntax.



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.