Posted: 12 Dec 2016 16:46 EST Last activity: 27 Sep 2017 9:32 EDT
How to use PageList property values in Report Definition Query as IN clause?
I am in need of one Report Definition, where the query should built like below.
Select Column1, column2.. From Table TableName
Where UserID IN ('abc','def','ghl',.....,'xyz')
So in WHERE Clause I need to use values of one property from PageList. something like Code-Pega-List.pxResults(*).UserID, So i need to get the results for all the userids present in that pagelist. I don't have another report-definition to use as sub-report, I need this with Page-List values only.
If you are planning to invoke the report definition either from Data page or an activity, then there is a way to address your problem.
Before invoking the report definition,construct the string for the where clause in a param variable and pass the variable to report definition.At run time, report definition captures the param value and execute the report for you.
There is no direct support for a page list property in report definition rule in the filter conditions. You can use the option suggested by @NPotnuru or you can use a value list property instead.
The option to provide page list property in report definition rule directly is an enhancement that is there is our backlog for a future release. Please reach out to your Pega account executive if you need this enhancement.
I have a similar requirement but a bit less complex. I am setting a list of values in a property as comma separated string and need to pass it as a filter criteria in report definition where it will generate the query like select x,y,z from table name where id in (comma separated values). Can you suggest me how I can achieve it as I am not calling the report definition in activity.