Question
Morgan Stanley
IN
Last activity: 28 Dec 2020 1:07 EST
Pass PageList property as a filter in Report Definition
Hi
Pega supports passing valuelist as a report definition filter (works when i pass filter as .valuelist). However, can we pass pagelist property as a filter, dint work when i tried with .pagelist().someproperty. Is there any other way other than manualy creating a CSV and pasing to RD.
As per https://collaborate.pega.com/question/how-use-pagelist-property-values-report-definition-query-clause, it was considered as an enhancement, not sure if it was added.
Pegasystems Inc.
AU
Hi Avinash,
Further to the suggestions in the linked post, I would additionally recommend a Value List property - at the same level as the Page List property - that is declaratively set to hold the values from the Page List you need to use in the Report Definition.
This way the values to use in the IN clause of the Report Definitions SQL are "ready to go" regardless of how the report is run. The procedure described in the linked article assumes that you are able to invoke the Report Definition from an Activity, which may not be your use case. This takes away the need to know to run what would be a wrapper activity in order for the report to run correctly.
As the Value List is not a single-value property, you won't be able to use a Declare Expression to set its values. A "Declare On Change" rule is a better fit, monitoring changes in the Page List property and re-building the Value List when changes are detected.