Question
Infosys
IN
Last activity: 31 Aug 2021 16:13 EDT
How to retrieve data from two different DB-tables(both are from different Databases) in a single report definition
Hi All, We have requirement such as we want to retrieve data from two different DB-tables(both are from different databases) in a single Report Definition without exposing the unexposed columns from both the tables. Note: One DB table is live DB-table and another one is archived DB-table. How can we achieve this?
***Edited by Moderator Kayla to update Platform Capability tags***
Ordina
NL
@VinayDnyaneshwarM I think you could do this through a view. We have a report definition where we refer to a view to show a single column for data from different classes, mapped to different tables. You can use a UNION statement and include the name of the database to get the correct rows.
Infosys
IN
Hi @BasG0629 thanks for the solution. But we have already tried this approach. We are not able to fetch Unexposed columns in this scenario. We want those columns also in our report definition.
Coforge DPA
GB