It's all about the answers!

Ask a question

Work Item Query Showing Parent/Child Relationships


Jon Lacks (11) | asked Jan 29 '10, 11:59 a.m.
edited Feb 19 '13, 5:27 p.m. by Susan Lafera (11)
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.

12 answers



permanent link
Patrick Streule (4.9k21) | answered Feb 01 '10, 4:23 a.m.
JAZZ DEVELOPER
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

permanent link
Aysim Dalmau (613) | answered Apr 14 '10, 3:37 p.m.
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

permanent link
Patrick Streule (4.9k21) | answered Apr 15 '10, 5:07 a.m.
JAZZ DEVELOPER
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

permanent link
Aysim Dalmau (613) | answered May 12 '10, 4:10 p.m.
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

permanent link
Vincent Huynh (14697) | answered May 16 '10, 2:17 p.m.
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-

permanent link
Jan Wloka (4161) | answered May 17 '10, 5:03 a.m.
JAZZ DEVELOPER
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-

permanent link
Fiona Lamont (1642) | answered May 28 '10, 2:42 p.m.
I also want to export a query to excel that shows me the story to which each task is related.

permanent link
James Leone (13613513) | answered Aug 19 '10, 2:25 a.m.
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?

permanent link
Jan Wloka (4161) | answered Aug 24 '10, 6:12 a.m.
JAZZ DEVELOPER
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?

permanent link
James Leone (2132) | answered Jul 28 '11, 7:30 p.m.
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?

Your answer


Register or 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.