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

Work Item Query Showing Parent/Child Relationships

We would like to run a work item query which outputs all story type work item for a given iteration along with their associated child task work items. We want the query to display this relationship e.g.

Story 1
Task
Task
Task
Story 2
Task
Task
Task

etc.

0 votes



12 answers

Permanent link
We would like to run a work item query which outputs all story type
work item for a given iteration along with their associated child
task work items. We want the query to display this relationship

In the Eclipse UI, you could enable the hierarchical view from the
'Relationships...' menu in the Work Items view's toolbar menu.

In the Web UI, you could add the 'Children' attribute as an additional
column on the 'Result Layout' tab.

--
Regards,
Patrick
Jazz Work Item Team

1 vote


Permanent link
Hi Patrick,
Your suggestion for showing parent child relationship using Web UI worked for me too, after looking for a way to do it so long.... so thank you :)
The only thing I can not do is to export to an excel file, the icon is up there but grayed out. Is this a configuration issue?

thank you
Aysim

0 votes


Permanent link
Hi Patrick,
Your suggestion for showing parent child relationship using Web UI
worked for me too, after looking for a way to do it so long.... so
thank you :)
The only thing I can not do is to export to an excel file, the icon is
up there but grayed out. Is this a configuration issue?

For unsaved queries, we currently do not support the export. But you can
save the query and then the icon should be enabled.

--
Regards,
Patrick
Jazz Work Item Team

0 votes


Permanent link
Hi Patrick,
Once I export it, the CSV loses the parent child relations; i.e, tasks are listed randomly(?), at least not under their parent stories. This is happening on Version: 2.0
Build id: I20090826-1029.

Any suggestions?

thank you
Aysim

Hi Patrick,
Your suggestion for showing parent child relationship using Web UI
worked for me too, after looking for a way to do it so long.... so
thank you :)
The only thing I can not do is to export to an excel file, the icon is
up there but grayed out. Is this a configuration issue?

For unsaved queries, we currently do not support the export. But you can
save the query and then the icon should be enabled.

--
Regards,
Patrick
Jazz Work Item Team

0 votes


Permanent link
I would like to know if we can import with parent-child relationships defined in the csv? Will this be available in 3.0?

Users are having to import 300+ work items and then manually drag-and drop to create the relationships (multiple levels of nesting).

Thanks,
Vince-

0 votes


Permanent link
Hello Vince,

yes, in RTC3.0 you can import partent/child relationships between work
items using the CSV import.

Regards,
Jan.

--
Jan Wloka
Jazz Planning & Tracking Team



On Sun, 16 May 2010 20:22:59 +0200, vhuynh
<vhuynh> wrote:

I would like to know if we can import with parent-child relationships
defined in the csv? Will this be available in 3.0?

Users are having to import 300+ work items and then manually drag-and
drop to create the relationships (multiple levels of nesting).

Thanks,
Vince-

0 votes


Permanent link
I also want to export a query to excel that shows me the story to which each task is related.

0 votes


Permanent link
Hello Vince,

yes, in RTC3.0 you can import partent/child relationships between work
items using the CSV import.

Regards,
Jan.

--
Jan Wloka
Jazz Planning & Tracking Team


Jan, Does your response imply this is not possible to do in 2.0.0.2M3?

0 votes


Permanent link
Yes, CSV import in RTC 2.x does not support any links.

Regards,
Jan.

--
Jan Wloka
Jazz Tracking & Planning Team


Jan, Does your response imply this is not possible to do in 2.0.0.2M3?

0 votes


Permanent link
Hello Vince,

yes, in RTC3.0 you can import partent/child relationships between work
items using the CSV import.

Regards,
Jan.

--
Jan Wloka
Jazz Planning & Tracking Team


Jan,

How is this done? Do I need a column named "parent" with the work item id as the value?

0 votes

1–15 items
page 1of 1 pagesof 2 pages

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
× 115

Question asked: Jan 29 '10, 11:59 a.m.

Question was seen: 16,882 times

Last updated: Feb 19 '13, 5:27 p.m.

Confirmation Cancel Confirm