Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Murali Kakarla (MuraliK9593) SMS Management & Technology
SMS Management & Technology
AU
MuraliK9593 Member since 2016 10 posts
SMS Management & Technology
Posted: Jan 26, 2017
Last activity: Mar 22, 2017
Posted: 26 Jan 2017 20:45 EST
Last activity: 22 Mar 2017 11:51 EDT
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***

To see attachments, please log in.
Reporting

Accepted Solution

Posted: 7 years ago
Posted: 8 Mar 2017 9:08 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Murali,

Apologies for the delayed response due to holidays, after cross checking with the product specialists the IN criteria is supported from Pega v7.2.2 onwards in BIX. Hope this information might be helpful to you.

Regards

Mahesh

To see attachments, please log in.
Posted: 7 years ago
Posted: 27 Jan 2017 4:30 EST
Vikash Ranjan Karn (Vikash Karn) Pegasystems Inc. Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Murali,

Please refer the attached document and let me know if this helps you in fulfilling your requirement.

Regards,

Vikash

To see attachments, please log in.
Posted: 7 years ago
Posted: 27 Jan 2017 4:50 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Murali,

Instead of passing both the pyIds in the same field you can have two pyId fields with your 2 case ids and use the OR condition among them.

For example:  Split your D condition into D1 -> "W-1970" and D2 -> "W-1980" then your condition could be like (D1 OR D2) AND A AND B AND C

Hope this might fulfill your requirement.

Regards

Mahesh

To see attachments, please log in.
Posted: 7 years ago
Posted: 3 Feb 2017 1:05 EST
Murali Kakarla (MuraliK9593) SMS Management & Technology
SMS Management & Technology
AU

Thank you Vikash and Mahesh for your responses. 

Solution suggested by you is certainly one of the workarounds. I would like to know why filter criteria for extract rule is not supporting IN criteria like the RD does.

Regards,

Murali

To see attachments, please log in.

Accepted Solution

Posted: 7 years ago
Posted: 8 Mar 2017 9:08 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Murali,

Apologies for the delayed response due to holidays, after cross checking with the product specialists the IN criteria is supported from Pega v7.2.2 onwards in BIX. Hope this information might be helpful to you.

Regards

Mahesh

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice