It's all about the answers!

Ask a question

RTC query that shows parent information of starting child

Renato Mori (10012230) | asked Sep 17 '14, 9:01 p.m.
I have two work item types: Story (parent) and Action (child). I want to create a query that shows information of the story filtered by the start date of the linked actions work item.
For example, show the headline, owner, points and state of a story that has an action work item that have the starting date between two dates.

Also, using the example... is possible to user between to filter a date in a work item query? I only found "is", "is not", "after" & "before" options.

Thanks in advance.

One answer

permanent link
sam detweiler (12.5k6195201) | answered Sep 17 '14, 11:15 p.m.
you can do
display fields from parent where
parent HAS  linked workitem (of  type x) AND where the linked work items start date is after x AND the linked workitems start date is before y

you can also display the ID & Summary of linked workitem in the result.

you CANNOT display additonal data FROM the linked workitems

Renato Mori commented Sep 22 '14, 5:46 p.m.

I sam,
I tried to make that query, but didn't workes.. Seems there's a date issue because I get all the requests but not filtering by date..
I took a screenshot of the query so anyone can tell me what I'm doing wrong.

sam detweiler commented Sep 22 '14, 6:21 p.m.

and just to make sure theĀ  dates are like this

child closed (or modified, or resolved) after June 5
child closed (or modified, or resolved) before July 4

Renato Mori commented Sep 23 '14, 10:44 a.m.

Yes, but in the example i post, the dates are prompted so the user can setup the range he wants, and the date filtered is the Constraint Date..
The one you posted worked for you?

sam detweiler commented Sep 23 '14, 12:16 p.m.

I don't have enough data in my test system to get actual results

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.