Resolve Linked Tables in Data Sources and problem launching Confirm screens via drill-down

Products affected: Confirm®


The scenario is that you have a Data Source that is powering a Dashboard Widget in a Confirm® Dashboard, and you wish to Link a table that isn't accessible via the Confirm Explorer. An example of which is the Job_Status_Log table.

If you utilise the Linked Table functionality in a Data Source (Help Topic - Reporting > Reporting Lookups > Data Source > Data Sources - Linked tables tab) you can link any Confirm table to your Data Source permitting you have similar columns present in your SQL. 

However, you will not be able to directly drill-down to tables such as the Job Status Log table, and those that aren't accessible directly from the Confirm Explorer.


The Confirm window/screen in question is derived from multiple, underlying tables.


UPDATED: May 29, 2018
This functionality isn't currently possibly in Confirm.