Database relation Workitem - Change set - files

Shmulik Tamari

(17●1●10●15) 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?

0 votes

1 answer

3,527 views

0 votes

Accepted answer

Permanent link

Stephanie Bagot

FORUM MODERATOR / JAZZ DEVELOPER (2.1k●1●5●13) Oct 21 '13, 11:03 a.m.

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

1 vote

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.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

rational-team-concert

× 42,899

extending

× 10,938

Question asked: Sep 09 '13, 8:57 a.m.

Question was seen: 3,527 times

Last updated: Oct 21 '13, 11:03 a.m.

Database relation Workitem - Change set - files

Shmulik Tamari

1 answer

3,527 views

0 votes

Accepted answer

Stephanie Bagot

Your answer

Follow this question

Question details

Related questions