It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,882
×10,914

question asked: Sep 09 '13, 8:57 a.m.
question was seen: 3,467 times
last updated: Oct 21 '13, 11:03 a.m.

Related questions

Database relation Workitem - Change set - files

0
Shmulik Tamari (17●1●10●15) | asked Sep 09 '13, 8:57 a.m.

I'm trying to get report from RTC Database :

all WorkItem in specific status -> all change sets -> all files in Change sets

where can I find  ERD of RTC Database.

or can I got the connection between the relevant tables?

Accepted answer

1
permanent link
Stephanie Bagot (2.1k●1●5●13) | answered Oct 21 '13, 11:03 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
RTC reports run off the datawarehouse since gathering a report off the live RTC DB can cause performance issues. Therefore, I would recommend running your report against the DW database instead.

We don't publish the ERD for RTC, but you can find similar information on the Information Center for the Data Warehouse in the Data Dictionary.
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/index.jsp?topic=%2Fcom.ibm.jazz.reports.doc%2Ftopics%2Fccm-roles.html


Shmulik Tamari selected this answer as the correct answer

Your answer

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.