It's all about the answers!

Ask a question

RTC work item query to export parent created in previous plan

Why Tea (25246) | asked Apr 29 '13, 9:18 a.m.
edited Apr 29 '13, 9:21 a.m. by Ralph Schoon (62.0k33643)
I have a rather straightforward RTC query to export work items as below.
1) Team Area is: xxx
2)  Planned for is: Current Iteration (picks up default plan)
3) Type is: Defect, Task, Story, Epic, Impediment, Retrospective

This work fine if the child and parent work items were created in the same plan. But if a Task is continued from previous plan, it's parent Story will not be exported. Is there a way to set up an RTC query so that a child work item's immediate parent is always exported regardless of when they were created?


/Why Tea 

3 answers

permanent link
Clement Liu (1.5k54249) | answered Apr 30 '13, 4:25 a.m.

Can you double check your child Task? Does it still have the parent link after it was transferred to new plan? 

According to this enhancement, the parent link will break. I am wondering if this is the cause for you not being able to export parent Story...

permanent link
sam detweiler (12.5k6189201) | answered Apr 30 '13, 6:39 a.m.
it depends on whether there was a COPY made to a new workitem to continue.  THAT is where the parent link was NOT copied to the new workitem..

the parent link of the original workitem should not have changed, and so you can include the Parent Link workitem in the query output by selecting the parent Link in the query builder.. (you may have to Show Links in the builder UI)

and technically this has nothing to do with 'Plan'. 
you asked for Current Iteration, regardless if there is a 'plan' above it.

A Plan is (organized) Work (workitems) done by People (Team) over Time (Iteration)

permanent link
Why Tea (25246) | answered May 01 '13, 5:58 a.m.
 Hi Sam,

When I continue a task in the next sprint, it's (parent) story  shows:
Planned For  Release 2.0/Sprint 1234  → Release 2.0/Sprint 1235.
I believe the parent link is copied with the work item (task).

I managed to use a workaround to get what I wanted by using a second query:
1) Team Area is: xxx
2)  Planned for is: Current Iteration (picks up default plan)
3) Type is: Story, Epic
4) Children > Planned For > Start Date after (including)
     - here I specify the date of the current sprint

With this query, I managed to get the stories for all the tasks in the current sprint.

I then paste the stories (parents) to the tasks (children) and run a VBScript to pair up the child-parent work items.

Kind of messy, but it works. Would be nice to be able to do in just one query.

/Why Tea

Your answer

Register or to post your answer.