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

BIRT - Table Join between LIVE_WORKITEM_CNT (WORKITEMS_SNAPSHOT) and LINKS (COMMON_SNAPSHOT) does not work.

Questions
Tags
Users
Badges
Fábio Castro
(63●1●12●15) Aug 19 '13, 7:18 a.m.
I'm using RTC 4.0.2

I have 2 main WI types, Requirement and Defect, and WI type task are added as child of this main WI.

I want to create a report that show total of Tak Sizes (Task attribute)  each main WI (Requirement or Defect) and the total of Expended Value (task attribute). When I "link" LIVE_WORKITEM_CNT with LINKS table by "nested tables" it works but I'm not able to sum the size and expended value of child task WI.

I think that the solution will be create a join Data Set between Child WIs and Links, and than create a nested tables with Parent WIs and Join Data, but the join between Child WIs and links does not work, the columns of LINKS Table come empty.

I can not understand how Nested Tables works but Join does not work. Someone can help me?

Thanks.

1 vote

2 answers
4,896 views
1 vote

2 answers

Permanent link
Fábio Castro
(63●1●12●15) Aug 19 '13, 10:06 a.m.
Just to complement, if I add a TARGET_ITEMID parameter in LINKS table with a Parent WI_ITEMID, in the join between Child WIs and LINKS, the LINKS columns of this requirement child WIs appear filled out. But If i remove the TARGET_ITEMID parameter, LINKS columns appear empty for all WIs child.

With Parent WI_ITEMID in the TARGET_ITEMID parameter of LINKS Table
Join
Join Parameters
Join Result

WithOUT Parent WI_ITEMID in the TARGET_ITEMID parameter of LINKS Table
Join
Join Parameters
Join Result

0 votes

Permanent link
Fábio Castro
(63●1●12●15) Sep 20 '13, 8:30 p.m.
I found the solution for join between 2 workitem data set... I did it using LIVE_SNAPSHOT to link table. with it the join table worked.

Actually the LIVE_SNAPSHOT fix others issues with join table, to get Iterations plan start and end date.

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
× 6,132

Question asked: Aug 19 '13, 7:18 a.m.

Question was seen: 4,896 times

Last updated: Sep 20 '13, 8:30 p.m.

Confirmation Cancel Confirm