BIRT - How to get tasks, which are linked to stories

Rolf Mueller

(1●1●1) Oct 23 '11, 9:29 a.m.

I would like to query all tasks, which belong to a story (defined through a child-relationship) to count the overall time spent for a story. I know how to query the workitem table, but I can't find the table, which holds the relationship information. Anyone who knows how to do this?

0 votes

1 answer

5,824 views

0 votes

One answer

Permanent link

Ethan Vogel

(51●4●2) Oct 24 '11, 1:47 p.m.

The relationship info is in the LINKS table in COMMON_SNAPSHOT.
One place this is discussed is at: http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part2/index.html
which is part of a good series of articles. Search for "Retrieving Linked Items" in that article.

0 votes

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

× 43,033

Question asked: Oct 23 '11, 9:29 a.m.

Question was seen: 5,824 times

Last updated: Oct 23 '11, 9:29 a.m.

BIRT - How to get tasks, which are linked to stories

Rolf Mueller

1 answer

5,824 views

0 votes

One answer

Ethan Vogel

Your answer

Follow this question

Question details

Related questions