Posted: 12 Feb 2020 20:01 EST Last activity: 13 Feb 2020 17:40 EST
How to get the records from one table which are not present in another
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?