It's all about the answers!

Ask a question

RTC - Database table relations

Ben Newell (3224) | asked 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:


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?

Kevin Ramer commented 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 )

Ben Newell commented 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 commented Mar 30 '13, 5:17 p.m.

Check this link out:


One answer

permanent link
Josh Crawford (984615) | answered Apr 11 '13, 5:05 p.m.
The data dictionary might be useful here as well.

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.