Question

5
Replies
156
Views
MuraliK9593 Member since 2016 10 posts
SMS Management & Technology
Posted: January 26, 2017
Last activity: March 22, 2017
Closed
Solved

How to specify IN criteria for BIX extract

Hi,

I want to specify IN filter criteria for one of the columns in BIX extract.

In Report Definition rules, when I specify comma separated values ("300", "3001") in Value column and specify Is Equal as relationship, Pega generates IN criteria for this.

WHERE ( "PC0"."Postcode" IN (? , ? ) )

This approach s not working in Filter Criteria of Extract rule form.

My requirement:

I need to specify few Case IDs in filter criteria so that only those cases get extracted when BIX extract is run. Refer to file Filter.png

I am expecting it to generate IN criteria but it is not.

Could you please help?

Thanks,

Murali

***Updated by moderator: Lochan to add Categories***

Reporting
Moderation Team has archived post
Share this page LinkedIn