Sorting and filtering work incorrectly with report definition
SummaryA 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 MessagesInvalid property reference in log tracer.
Steps to Reproduce
- Create section with repeat grid, sourced from report definition with index class join.
- Create grid column with link control, that has property reference from index class.
- Try to filter values on it, or make a sorting with descending order.
Root CauseA 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.PropertyName
syntax.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.PropertyName
The embedded contains the link configured using the .pxPages(... syntax.
Published January 30, 2017 - Updated January 31, 2017