RTC query that shows parent information of starting child
Hi,
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.
Renato.
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.
Renato.
One answer
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
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
Comments
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.
and just to make sure the dates are like this
child closed (or modified, or resolved) after June 5
and
child closed (or modified, or resolved) before July 4
and
etc
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?
I don't have enough data in my test system to get actual results