Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC - Database table relations

Questions
Tags
Users
Badges
Ben Newell
(3●2●2●4) Mar 28 '13, 3:34 p.m.
I know it's not recommended that we query the database directly, BUT we kind of rely on it for complex data analysis.

I'm trying to figure out how to get all of the work item statuses that have been set in RTC. Basically, get the history of a "defect" work item and view how many times it went from "In Progress" -> "Resolved" -> Etc..

So I basically need to build a relationship between these two tables:

MODEL.WORK_ITEMS
and
WORKITEM_SNAPSHOT.STATE

The latter table is is an educated guess about the work item statuses. It appears to be the table that I need. Unfortunately I'm having a hard time getting all of the states for a particular work_item.

Any help?

0 votes

Comments
Kevin Ramer
Mar 28 '13, 3:44 p.m.
There are "FROM" and "TO" tables in the snapshots that are supposed to record changes like this ( not an expert, just know that the tables are there ) e.g. WORKITEMS_SNAPSHOT.WORKITEM_CHNGS_FROM

Ben Newell
Mar 29 '13, 7:30 a.m.
Thanks for the reply Kevin. I don't see this table "WORKITEMS_SNAPSHOT.WORKITEM_CHNGS_FROM" in the database. Here are the WORKITEMS_SNAPSHOT tables that are available: As you can see there is a WORKITEMS_SNAPSHOT.WORKITEM_CHNGS table but no "TO" or "FROM". I'm using RTC v 4.0.1 and SQL Server 2008.

Clement Liu
Mar 30 '13, 5:17 p.m.
Check this link out: https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20 WORKITEMS_SNAPSHOT.WORKITEM_CHNGS_FROM is a db view though. 

1 answer
13,010 views
0 votes

One answer

Permanent link
Josh Crawford
(984●6●15) Apr 11 '13, 5:05 p.m.
The data dictionary might be useful here as well.
https://jazz.net/help-dev/clm/topic/com.ibm.jazz.reports.doc/topics/ccm-roles.html

1 vote

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
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
× 102
× 82

Question asked: Mar 28 '13, 3:34 p.m.

Question was seen: 13,010 times

Last updated: Apr 11 '13, 5:05 p.m.

Confirmation Cancel Confirm