How to fetch data values from different tables
I want to fetch values from two or more external tables of a DB and display them in a grid/table format in the UI. How can i do that
***Updated by Moderator: Marissa to update categories***
Pegasystems
IN
Does that translate to a join or a union in SQL?
TCS
IN
Hi Rajiv ,
I have different cases which i want to work on... So, it will be really appreciable if you could just explain both scenarios.
Thanks
Accepted Solution
Pegasystems
IN
Union in SQL means you are getting results from one table and appending the results from another table to the initial results (all this in DB) and then returning the full set of results.
Join in SQL means you are using a set of conditions to get columns from one or multiple tables (not appending rows)
Pega Systems
IN
Using "Database Class Mapping" wizard, create the classes for those external tables.
Then, create a Report Definition Rule with relevant joins and populate data in the grid based on that Report Definition.
Rabobank
AU
Union operation cannot be achieved through report definition (Click here). One should write custom SQL and use it from RDB-List method to achieve this scenario.
Pegasystems
IN
Unions are supported from 7.2 onwards.
Pegasystems Inc.
IN
Can you please detail the steps on how to implement union functionality in RDs unsing 7.2?
We've a req to pull data from 4 different underlying tables and consolidate the result sets into one.
We intent to use only one RD to achieve above functionality.
Thanks