Question
PerseusX Incorporated
US
Last activity: 8 Jan 2017 12:03 EST
How to achieve SQL union or union all in pega report definition
How to achieve SQL union or union all in pega report definition
***Updated by moderator: Lochan to update Categories***
Pegasystems Inc.
IN
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
Pegasystems
IN
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".
Virtusa
US
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?
Capgemini Sverige
SE
Hi SHiva,
You can try to create a View (that contains union of the 2 table results) in the database schema and then Map the Report Definition to the View class
Cognizant Technology Solutions
IN
I would suggest creating a DB view and using that as the data source for your RD
Virtusa
US
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.