Question6Replies2820Views×Close popoverAvinash Haridasu (Avinash.Haridasu) Morgan Stanley Morgan Stanley IN View ProfileSend Message Avinash.Haridasu Member since 2014 283 posts Morgan Stanley Posted: July 18, 2018Last activity: November 7, 2018Posted: 18 Jul 2018 8:29 EDTLast activity: 7 Nov 2018 16:32 EST 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 agoPosted: 18 Jul 2018 9:02 EDT×Close popoverVikash Ranjan Karn (Vikash Karn) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View ProfileSend MessageVikash 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 agoPosted: 18 Jul 2018 10:09 EDT×Close popoverMahesh Sawant (Mahesh_Sawant) Capgemini SSA Capgemini AU View ProfileSend MessageMahesh_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 agoPosted: 18 Jul 2018 10:17 EDT×Close popoverGayatri Nistala (Gayatri) incessant incessant IN View ProfileSend MessageGayatri incessant replied to Avinash.HaridasuHI, You can achieve this by creating a view, later on you can map this in ReportDefinition. Posted: 2 years agoPosted: 18 Jul 2018 12:57 EDT×Close popoverKrishna Chaitanya Abburi (KC-Abburi) Crochet Technologies Crochet Technologies IN View ProfileSend MessageKC-Abburi Crochet Technologies replied to Avinash.HaridasuHi Please follow what "Mahesh" suggested. Thanks Posted: 2 years agoPosted: 19 Jul 2018 5:15 EDT×Close popoverAvinash Haridasu (Avinash.Haridasu) Morgan Stanley Morgan Stanley IN View ProfileSend MessageAvinash.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 agoPosted: 7 Nov 2018 16:32 EST×Close popoverTim Turbett (TURBT) PEGA Technical Solutions Director PEG US View ProfileSend MessageTURBT 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?