Question 6 Replies 2908 Views × Close popover Avinash Haridasu (Avinash.Haridasu) Morgan Stanley Morgan Stanley IN View Profile Send Message Avinash.Haridasu Member since 2014 286 posts Morgan Stanley Posted: July 18, 2018 Last activity: November 7, 2018 Posted: 18 Jul 2018 8:29 EDT Last activity: 7 Nov 2018 16:32 EST Closed 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*** Reporting Share × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover 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 ago Posted: 18 Jul 2018 9:02 EDT × Close popover Vikash Ranjan Karn (Vikash Karn) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View Profile Send Message Vikash Karn PEGA replied to Avinash.Haridasu 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 Posted: 2 years ago Posted: 18 Jul 2018 10:09 EDT × Close popover Mahesh Sawant (Mahesh_Sawant) Capgemini LSA Capgemini AU View Profile Send Message Mahesh_Sawant Capgemini replied to Avinash.Haridasu 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 Posted: 2 years ago Posted: 18 Jul 2018 10:17 EDT × Close popover Gayatri Nistala (Gayatri) incessant incessant IN View Profile Send Message Gayatri incessant replied to Avinash.Haridasu HI, You can achieve this by creating a view, later on you can map this in ReportDefinition. Posted: 2 years ago Posted: 18 Jul 2018 12:57 EDT × Close popover Krishna Chaitanya Abburi (KC-Abburi) Crochet Technologies Crochet Technologies IN View Profile Send Message KC-Abburi Crochet Technologies replied to Avinash.Haridasu Hi Please follow what "Mahesh" suggested. Thanks Posted: 2 years ago Posted: 19 Jul 2018 5:15 EDT × Close popover Avinash Haridasu (Avinash.Haridasu) Morgan Stanley Morgan Stanley IN View Profile Send Message Avinash.Haridasu Morgan Stanley replied to Avinash.Haridasu Ok, 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 ago Posted: 7 Nov 2018 16:32 EST × Close popover Tim Turbett (TURBT) PEGA Technical Solutions Director PEG US View Profile Send Message TURBT 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?