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

 Pratiksha Patil (PratikshaP9851)
Deloitte

Deloitte
IN
PratikshaP9851 Member since 2022 1 post
Deloitte
Posted: Apr 6, 2022
Last activity: Apr 6, 2022
Posted: 6 Apr 2022 6:08 EDT
Last activity: 6 Apr 2022 7:45 EDT
Closed

How to compare internal & external table data using report definition?

we have 1 SQL data table & 1 PEGA data table internal data type with local records.

We want to have non matching data from one of this two tables.so Is there any way to have union or intersection of table from report definition?


***Edited by Moderator Marije to change type from Pega Academy to Product, added Product details and Capability tags****
To see attachments, please log in.
Pega Platform
Data Model
Reporting

Posted: 2 years ago
Posted: 6 Apr 2022 7:45 EDT
Marije Schillern (MarijeSchillern)
MOD
Senior Knowledge Management Specialist
Pegasystems Inc.
GB

@PratikshaP9851  please could you take a look at the advice given in previous questions:

How to achieve SQL union or union all in pega report definition

Use Of Union in Pega 7.2

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

How to perform a Union using a report definition

Class Joins in RD

Replicate SQL with sub-queries inside PRPC

To see attachments, please log in.

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