RTC Common_Snapshot.LINKS table not available from Insight
I need to create an Insight report that shows data from RQM and RTC. Specifically, I need to show the ID, Summary, Due Date, etc of Defects created when running TestScripts in RQM, where a Tested By cross server link is set up between RTC and RQM.
I assume this information is in the COMMON_SNAPSHOT.LINKS we used in BIRT (I might be wrong, never created a report for cross-server links). This table as it appears in BIRT can be seen in this screenshot:
http://img825.imageshack.us/img825/3499/birtlinkstable.jpg
But when accessing RTC data from Insight Metadata Wizard, that table is not available in COMMON_SNAPSHOT, as you can see in the next screenshot:
http://img600.imageshack.us/img600/9312/insightlinkstable.jpg
I'm not sure why that table is not appearing. Even if it were there... is that the right table to use for accessing cross-server links like the ones I need to report on? (RQM ScriptStep related to a Defect stored in RTC using cross-server links like "Tested By").
Any help would be appreciated.
Thank you!
(Re-posted here from https://jazz.net/forums/viewtopic.php?t=13803)
I assume this information is in the COMMON_SNAPSHOT.LINKS we used in BIRT (I might be wrong, never created a report for cross-server links). This table as it appears in BIRT can be seen in this screenshot:
But when accessing RTC data from Insight Metadata Wizard, that table is not available in COMMON_SNAPSHOT, as you can see in the next screenshot:
I'm not sure why that table is not appearing. Even if it were there... is that the right table to use for accessing cross-server links like the ones I need to report on? (RQM ScriptStep related to a Defect stored in RTC using cross-server links like "Tested By").
Any help would be appreciated.
Thank you!
(Re-posted here from https://jazz.net/forums/viewtopic.php?t=13803)