Question6Replies2715Views Avinash.Haridasu Member since 2014 264 posts Morgan Stanley Posted: July 18, 2018Last activity: November 7, 2018 Closed How to perform a Union using a report definitionHiI 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*** Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 2 years agoVikash Karn PEGA replied to Avinash.HaridasuHi, 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 Posted: 2 years agoMahesh_Sawant Capgemini replied to Avinash.HaridasuHi, 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 Posted: 2 years agoGayatri incessant replied to Avinash.HaridasuHI, You can achieve this by creating a view, later on you can map this in ReportDefinition. Posted: 2 years agoKC-Abburi Crochet Technologies replied to Avinash.HaridasuHi Please follow what "Mahesh" suggested. Thanks Posted: 2 years agoAvinash.Haridasu Morgan Stanley replied to Avinash.HaridasuOk, seems like creation of view is the only option. I think this is a very common usecase. Can we not raise a feedback ? Posted: 2 years agoTURBT PEGA replied to Avinash.Haridasu 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?