How do you show all parent tasks that have subtasks in progress?

I want a JQL query or list of parent issues that are truly in progress. This means if it is a story with sub-tasks and the sub-tasks have been started, I want to show just the story. If the issue has no sub-tasks I want it to be shown if in progress.

Basically I want to show a high level report of issues in progress and not get into the details of sub-tasks.

1 answer

1 accepted

This widget could not be displayed.
Peter Bengov Community Champion Feb 12, 2015

Hey David,

Using the issueFunction JQL function that comes with Script Runner you can do the following:

(issueFunction in parentsOf("issuetype = Task And status not in (open, closed)") AND issuetype = Story) OR (issuetype = Story AND status = "In Progress" AND!(issueFunction in hasSubtasks()))


You need to replace "Task" with "Sub-task" in the parentsof subquery, beside that the answer is correct

This was able to get me where I wanted in the end. I didn't specify the exact details, but I actually ended up with: ((issueFunction in parentsOf("issuetype in subTaskIssueTypes() And status not in (open, closed)")) OR (issuetype not in subTaskIssueTypes() and status not in (open, closed) AND!(issueFunction in hasSubtasks()))) and Sprint in openSprints() I used subTaskIssueTypes() to ensure any sub-task type is considered and I also need to make sure I only showed issues in the current sprint.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

54 views 1 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you