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***
Accepted Solution
Updated: 5 May 2016 6:44 EDT
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)
Accepted Solution
Updated: 5 May 2016 6:44 EDT
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.
Optus
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 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