It's all about the answers!

Ask a question

link between defect and component in data warehouse


Alberto Ceravolo (1698) | asked Mar 26 '10, 5:03 a.m.
Hi. i'm interrogating the data warehouse by jdbc. I need to know if the link between a defect and a component is stored in the datawarehouse. I noticed that when I create a link between a defect and a component in the RTC eclipse client, a new record is added in the "auditable_link" table of the datawarehouse. Indeed the column "TARGET_REF_REFERENCED_ITM_TM_D" stores the id of the defect, but i cannot find the id of the component in that table. The columns "SOURCE_REF_REFERENCED_ITM_TM_D" and "SOURCE_REF_INTERNAL_ID" don't store the component's id, but
I noticed that the second part of component's id and the second part of the values in "SOURCE_REF_REFERENCED_ITM_TM_D" and "SOURCE_REF_INTERNAL_ID" columns are the same. So, any suggestions, ideas? Thanks.

Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.