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***
@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.