It's all about the answers!

Ask a question

RTC query that shows parent information of starting child


Renato Mori (10012130) | asked Sep 17 '14, 9:01 p.m.
JAZZ DEVELOPER
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.

One answer



permanent link
sam detweiler (12.5k6185201) | 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


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

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
and
child closed (or modified, or resolved) before July 4
and
etc



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

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.