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

BIRT report dont show all links (Parent-child relationship)

Good day everyone,

Im trying to do a BIRT report that shows me a workitem child-parent relation:

CHILD (TASK)     PARENT(MILESTONE)
0023                        01234
0024                        01235

I created 3 data sets:

1- Live Work Item CNT (list of al workitems filtering by "Type = 'Task')
2- Common Snapshot - LINKS (List of all links filtered by Type=parentworkitem)
3- Join dataset (LiveWorkItemCNT.WI_ITEMID = LINKS.SOURCE_ITEMID)

The problem comes out when i do that JOIN because the result shows me some CHILDS with no PARENT, and if i check the task (in RTC IDE)  i can see it has a parent.

im trying to create snapshots from every plan but nothing happen.

i share some caps:

For task (tarea) 2549 preview doesnt show any results
Report Preview showing that task 2549 doesnt have any parent

RTC shows that task have a parent
RTC Showing task 2549 have a parent

Hope anyone can help me

Thx in advance

0 votes

Comments

Hello Rafael ,

Is your issue fixed ? I want to display a report with columns Work Item id,summary and also the parent info like id, summary, blockers . Do you have any documenation for this ?

Thanks..Johnson



One answer

Permanent link
Is there another table that contains links?

im using LINKS, AUDITABLELINKS, LINKCLOSURE.RELATION and i cant get the information

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.

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: Mar 06 '13, 7:57 p.m.

Question was seen: 1,720 times

Last updated: Apr 16 '13, 1:21 p.m.

Confirmation Cancel Confirm