How to search issues by Sub-Task status

hirok September 3, 2012

I'd like to create a query which searches for issues whose childs(Sub-Tasks) are ALL in 'Resolved' status.

e.g.)
*Issue A
-> Sub-Taks1 - Resolved
-> Sub-Task2 - Resolved

*Issue B
-> Sub-Task1 - Resolved
-> Sub-Task2 - Open

In this case, only the issue A should be searched by that query.
Could you please let me know how I can create such query using JQL?

1 answer

1 accepted

0 votes
Answer accepted
Thomas Heidenreich
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 3, 2012

With the Craftforge JQL Functions Plugin from https://marketplace.atlassian.com/plugins/org.craftforge.jira.craftforge-jql-functions-plugin

you can use the following query:

issue in parentIssuesFromQuery("resolution is not empty") and issue not in parentIssuesFromQuery("resolution is empty")

Hope this helps

Thomas

hirok September 6, 2012

Hi Thomas,

I installed the plugin and tried the query as you specified.
It works great as I expected.

Thank you very much!!
hiro

Thomas Heidenreich
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 6, 2012

Glad I could help, but why did't you accept my answer ;)

hirok September 6, 2012

Oh, I found it!

hirok September 6, 2012

I'm sorry, but I still don't know how to accept your answer. Any button or link available??

Suggest an answer

Log in or Sign up to answer