Skip to main content

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.

Question

 Dmitry Kristalov (DmitryK3577)
Lanit BPM
RU
DmitryK3577 Member since 2017 38 posts
Lanit BPM
Posted: Jun 17, 2020
Last activity: Jun 17, 2020
Posted: 17 Jun 2020 2:55 EDT
Last activity: 17 Jun 2020 14:52 EDT
Closed

Display Results of union data from 2 classes/report definitions in a single Report Definition

Hi, 

I have requirement where i need to display different data from 2 classes in one single RD but in different rows (like on pictures 1 and 2) .To achieve this using joins did not work, how can this be achieved? Does Platform have a functionality similar to SQL "Union" (analogous to a similar request like on picture 3)?

To see attachments, please log in.
Pega Platform 7.4
Reporting
Insurance
System Architect

Posted: 5 years ago
Posted: 17 Jun 2020 14:52 EDT
Ron Lee (RonLee_GCS) Principal Software Solutions Engineer
Pegasystems Inc.
US

I don't know of any way to explicitly specify a union through the report definition rule interface.

My suggestion would be to create a database view that is populated using your union query, and base the report on that. Database views can be treated the same as database tables in Pega - i.e., you can map a class to a view as if it was a table. You can then create your report from that class.

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

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.

Close Deprecation Notice