Question
Morgan Stanley
IN
Last activity: 7 Nov 2018 16:32 EST
How to perform a Union using a report definition
Hi
I would like to perform a union on two different classes with same set of properties.
How do i achieve this ?
***Edited by Moderator Marissa to update platform capability tags***
Pegasystems Inc.
IN
Hi,
Please refer the below link:
https://collaborate.pega.com/question/how-achieve-sql-union-or-union-all-pega-report-definition
Regards,
Vikash
Capgemini
AU
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
incessant
IN
HI,
You can achieve this by creating a view, later on you can map this in ReportDefinition.
Crochet Technologies
IN
Hi
Please follow what "Mahesh" suggested.
Thanks
Morgan Stanley
IN
Ok, seems like creation of view is the only option.
I think this is a very common usecase. Can we not raise a feedback ?
PEG
US
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?