Question

9
Replies
15804
Views
Close popover
Ramarao Janapati (RamaraoJ)
United Health Group

United Health Group
IN
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.