RTC BIRT Report: How to recursively traverse all the work items with the "Depend On" linkage?

Clement Liu

(1.5k●5●43●49) May 01 '14, 12:09 p.m.

I can use embedded dataset but the depth of the linkage tree has to be known at the build time. I'm wondering if there is any way to dynamically traverse all the work items recursively.

Here is an example:

workitem-1

depends on

workitem-2

depends on

workitem-3

.....

How do I build a BIRT report to dynamically traverse deep down to the bottom of the tree and bring back all the work items?

Thanks.

0 votes

1 answer

4,369 views

0 votes

Accepted answer

Permanent link

You can't recurse indefinitely, but what you can do is pick an arbitrary maximum depth, create a table based on a scripted dataset that loop that number of times and then add to the table elements linked to datasets to retrieve each work item and then get the itemId of its related work item.

Clement Liu selected this answer as the correct answer

1 vote

Comments

Ajay Mallikarjunaiah

Jul 30 '14, 7:30 a.m.

Hello Clement Liu,

Could you please explain a bit more how you achieved the above requirement.
Thank you in advance.
Ajay

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

× 42,896

usage

× 12,019

birt

× 324

Question asked: May 01 '14, 12:09 p.m.

Question was seen: 4,369 times

Last updated: Jul 30 '14, 7:30 a.m.

RTC BIRT Report: How to recursively traverse all the work items with the "Depend On" linkage?

Clement Liu

1 answer

4,369 views

0 votes

Accepted answer

Bill Taylor

Comments

Ajay Mallikarjunaiah

Your answer

Follow this question

Question details

Related questions