RTC fields mapping to backend DB tables and fields

For parent-child I'm unable to find a table called LINKS as mentioned in the BIRT RTC client linked work items.

http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part2/

If I go to Oracle RTC DB I'm unable to find table LINKS in common snapshot schema or in any other snapshot.

**NOTE: LINKS is the table that needs to maintain the relationship between parent and child.

Link is created between 2 work items by clicking on Link tab while creating work items (defect/task) in RTC.

For parent-child I'm unable to find a table called LINKS as mentioned in the BIRT RTC client linked work items.

http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part2/

If I go to Oracle RTC DB I'm unable to find table LINKS in common snapshot schema or in any other snapshot.

**NOTE: LINKS is the table that needs to maintain the relationship between parent and child.

Link is created between 2 work items by clicking on Link tab while creating work items (defect/task) in RTC.

The LINKS 'table' is really a view onto the live data in the repository. It's not stored in the data warehouse at all. So I don't think you'll be able to access this information by direct DB access.

james
RTC Reports Team Lead

Hi James,

Thanks for the response. Where do I find the relationship between a defect (parent) and tasks (children) in the backend DB?

Thanks!

Hi James,

Thanks for the response. Where do I find the relationship between a defect (parent) and tasks (children) in the backend DB?

Thanks!

I don't know. Our storage model is not public API, and you shouldn't try to access it this way. It would be in one of the tables defined by the Links component.

james