Question
Virtusa
AU
Last activity: 13 Feb 2020 17:40 EST
How to get the records from one table which are not present in another
All,
We are using Pega 7.2.2, we maintain a data table called as Approvers, the requirement is to display the list of operators which are not present in Approvers table. If I go for a Report Definition which is of Data-Admin-Operator-ID class and join with Approvers table, is there any join condition or any way which would display the list of operators which are not present in Approvers table? Or Do I need to have an activity to accomplish this?
Any suggestions would be much appreciated.
Cheers,
Satya
Accepted Solution
Updated: 13 Feb 2020 17:40 EST
Pegasystems Inc.
CA
You need to use sub-report.
1. Create a report that returns the list of approvers.
2. Create a report in Data-Admin-Operator-ID class. Add the above report as a sub-report in this report. In the sub-report join condition, select 'Do not match rows'.
Virtusa
AU
Thanks Praneeth. That helped. Further to your post, if anyone facing issue in configuring sub report for the above requirement then they can refer the below article as well -