Jazz Register Log in
Jazz Forum Welcome to the Jazz Community Forum

Welcome to the Jazz Community Forum

 Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
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
4,053 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

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

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

Question was seen: 4,053 times

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

Confirmation Cancel Confirm