How to include sub query in reports

Question

Replies

397

Views

Member since 2012

VirtusaPolaris

Closed

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');

PEGA

replied to Janani.M.A

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"