Tasks and Sub-tasks Query

[Andres Dominguez]

Hello,

I need help with a query that shows me stories that meet the below criteria:

-The story has sub-tasks with summary ~ XYZ

-And those sub-tasks the status is not in (done, cancelled)

Can someone help with this? 

Thank you,

AD

[Jack Brickey · Accepted solution]

@Andres Dominguez, so the key is in the first part "story has sub-tasks". Unfortunately OOTB you can't find that. You can use an addon like scriptrunner and it's "issuefunction" function to do that. something like...

issueFunction in hasSubtasks() and...

[Thomas Deiler]

Small annotation before you use a sledge-hammer to crack a nut. This "has sub-tasks" function could be covered by the AM Utils plugin.

[Jack Brickey]

Excellent thanks @Thomas Deiler. I was not aware of that addon. Wish it was on Cloud I could sure use it! :-(