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

 Janani Melnattamai Athmarao (Janani.M.A) Associate Consultant
VirtusaPolaris
IN
Janani.M.A Member since 2012 1 post
Posted: Apr 1, 2017
Last activity: Apr 4, 2017
Posted: 1 Apr 2017 4:39 EDT
Last activity: 4 Apr 2017 5:22 EDT
Closed

How to include sub query in reports

Report

I want to know how to configure sub reports to implement the following query.

select * from pr4_rule_vw where PZINSKEY in (select pxhistoryforreference from pr4_history_rule where pxtargetrulesetversion='03-01-01');

Reporting
Posted: 6 years ago
Posted: 3 Apr 2017 17:07 EDT
Ron Lee (RonLee_GCS) Principal Software Solutions Engineer
Pegasystems Inc.
US
Report

Are you sure you need a SubReport? It doesn't look like you are displaying any columns from pr4_history_rule.

You might be able to do this with a report in Data-Rule-Summary that does a class join with History-Rule, using the appropriate join conditions:

.pzInsKey = HistoryRule.pxHistoryForReference AND HistoryRule.pxTargetRuleSetVersion = "03-01-01"

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