Hi,

Please refer the below link:

https://community1.pega.com/community/product-support/question/how-achieve-sql-union-or-union-all-pega-report-definition

Regards,

Vikash

Hi,

You can create a View (that contains the union of the 2 table results) in the database schema and then Map the Report Definition to the View class

HI,

You can achieve this by creating a view, later on you can map this in ReportDefinition.

Hi

Please follow what "Mahesh" suggested.

Thanks  

Ok, seems like creation of view is the only option.

I think this is a very common usecase. Can we not raise a feedback ?

I'm on 7.1.8, and am trying to replicate the OOTB "rule overrides" functionality in a RD.  OOTB, this uses an activity to create SQL that contains a Union.

Is there really no way to create a Union via a Report Definition?