It's all about the answers!

Ask a question

Is there any way to know a root parent using work item view in RTC?

Junko Tomonoh (2111) | asked Jul 20 '12, 4:23 a.m.
Let us say you create TASK-10 as a child of PLAN-A, TASK-11 as a child of TASK-10 and DEFECT-11 as a child of TASK-11 in RTC v3.0.1.
  • PLAN-A
    • TASK-10
      • TASK-11
        • DEFECT-11
If you add "Parent" item to a work item view to inquire DEFECT-11, you can see the parent TASK-11 but can not see the root parent PLAN-A.
I know you can see the hierarchy using a plan view, but you can not export data from a plan view, right? I would like to know the way to know a root parent using work item view or any other alternatives, if any.

Millard Ellingsworth commented Jul 23 '12, 8:06 p.m.

Just to be clear, a work item is not a "child" of a plan. A work item appears on a plan because its Filed Against and Planned For attributes match the Team Area and Iteration configuration for the plan. Using your example, the "root" work item for the tree is Task-10.

You can export from a Plan (in an XML format compatible with Microsoft Project), though you can't do a normal work item export from a plan (the way you can with a query). But if you want to export all of the items that would appear on a plan, you can query on the correct Filed Against and Planned For attributes to get them all.

One answer

permanent link
Aradhya K (1.4k54345) | answered Jul 23 '12, 5:14 a.m.
 From Plan view you can export the content to MSP XML.

This table shows how parts of Microsoft Project plans map to parts of RTC plans during export.

Rational Team Concert
Microsoft Project XML

Plan name

Project name

The start date of the iteration of the plan.

Project start date

The end date of the iteration of the plan.

Project finish date

Work item with children

Summary task

Leaf work items


Work item summary

Task name

Work item parent-child hierarchy

Outline number or Outline level

Work item description

Task notes

Work item estimate or corrected estimate, if set.

Task Duration or Work

If time spent less than estimate then the difference between time spent and estimate; else zero.

Remaining Duration

Time spent on the work item.

Actual Work or Actual Duration

The timestamp when the work item is first moved to a state part of the In progress state group.

Actual start

Time spent and estimate.

If time spent is greater than or equal to estimate then PercentComplete is 100% else 0%.

Constraint type

Constraint type

Constraint date

Constraint date

Due date of the work item


Owner of the work item

Information about the resource and task assignment

Junko Tomonoh commented Jul 24 '12, 3:20 a.m.

Thank you for your response. Can you export any additional attributes like using this functionality, or customizing this functionality itself? For example, we add "actual start date" attribute on a TASK.

Aradhya K commented Jul 24 '12, 6:57 a.m. | edited Jul 24 '12, 7:00 a.m.

Currently the MSP XML export only supports the ones listed. Also this feature does not allow customization to add more attributes to be exported.

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.