Question
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***
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
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)
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.
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.
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
Does that translate to a join or a union in SQL?