JQL to show resolved sub-tasks only if the parent Story is Unresolved

Chris Puffe

Trying to use Plans to create a view that shows all open stories, and the subtasks underneath them regardless of status.  

I've tried the following but this shows sub-tasks for completed stories as well:

project = XXX AND issuetype = Story AND status in (Blocked, Deploy, "In Progress", QA, "Ready for QA", "To Do") or project = XXX AND issuetype = Sub-task AND status in (Blocked, Deploy, Done, "In Progress", QA, "Ready for QA", "To Do") ORDER BY status DESC, created DESC

 

Looking to include completed sub-tasks of an issue, but only when that parent issue is still open (unresolved).  Completed sub-tasks for resolved parent issues should not appear.

Bill Sheboy

Hi @Chris Puffe 

I do not believe that you can perform that type of query with out-of-the-box JQL.  It would require checking the status of children to select their parents.

There are marketplace add-ons for JQL scripting which could help do this, such as ScriptRunner.

And... Your existing query uses AND and OR statements, but does not group them with parenthesis to enforce the operation order you want.  You probably want something like:

(condition1 AND condition2) OR (condition3 AND condition4)

Best regards,

Bill