Question
Morgan Stanley
Morgan Stanley
IN
Morgan Stanley
Posted: Jul 18, 2018
Last activity: Nov 7, 2018
Last activity: 7 Nov 2018 16:32 EST
This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.
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***
Hi,
Please refer the below link:
https://collaborate.pega.com/question/how-achieve-sql-union-or-union-all-pega-report-definition
Regards,
Vikash
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
HI,
You can achieve this by creating a view, later on you can map this in ReportDefinition.
Hi
Please follow what "Mahesh" suggested.
Thanks
Ok, seems like creation of view is the only option.
I think this is a very common usecase. Can we not raise a feedback ?
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?
Question
Discussion
Question
Question
Question
Question
Discussion
Question Solved
Question
Question Solved
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.