Hi John,

Please refer to the below post.

https://pdn.pega.com/community/pega-product-support/question/use-union-pega-72

 I hope it helps!

Regards,

Gisela

In addition to the details from @Gisela_R, the report definition SQL will generate UNION ALL by default. To generate UNION, you should select the option "Remove duplicate rows".

Hi,

I wanted to perform union on Assign-Worklist and Assign-WorkBasket class. So i created the report in Assign- class. but i am gettin the below error since it is a abstract class. 

 Error:

** ** The report has an abstract class ['Assign-'] with no data as a source, and cannot be resolved to a concrete class containing data. ** The report has an abstract class ['Assign-'] with no data as a source, and cannot be resolved to a concrete class containing data.

how to perform union on Assign-Worklist and Assign-Workbasket classes?

I would suggest creating a DB view and using that as the data source for your RD

Hi Prashanth,

Yes I did that approach but i am curious whether the Pega provides a way to handle this common scenario with the new option of option "Include all descendant classes" in 7.2. 

With "View" approach, i had to create a new class, Data-admin-DB-Table mapping and hard code that class for pxObjClass in the view.