Question

2
Replies
152
Views
Madhusudan Ramamurthy (MadhusudanR)

IN
MadhusudanR Member since 2020 2 posts
Posted: August 24, 2020
Last activity: August 24, 2020
Posted: 24 Aug 2020 7:30 EDT
Last activity: 24 Aug 2020 21:23 EDT

Building an IN clause in PEGA Report Definition

Hi Team,

We are building a dynamic query in the PEGA Report Definition where in to a database column we need to send list of values like as we pass in IN clause.

 

Eg:

Select * from table where organization_id IN (1,2,3,4,5)

 

But as per current pega capability (Ver. 7.4) we don't see such option available. Is there any alternate option.

 

***Edited by Moderator Marissa to update Content Type from Discussion to Question***

Pega Platform 7.4 Reporting Financial Services System Architect