Question

9
Replies
15183
Views
RamaraoJ Member since 2014 3 posts
United Health Group
Posted: December 12, 2016
Last activity: September 27, 2017
Closed
Solved

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.

Could you Please help, how can we achieve this.

Thank you very much in advance for the help.

Thanks,

Ramarao.

Reporting
Moderation Team has archived post
Share this page LinkedIn