Hi, How could I search parent issues whose subtask meet certain condition

There are some other teams create subtasks in their board and than assign it to my team members.

But the scrum board only show standard task but not sub task in plan mode.

I want to create a filter to search all parent issues whose subtask meet certain condition, is it possible without any additional plugin?

For example, I need some approach to realize:

find_parent_issue_of (issuetype in subtaskIssueTypes() AND assignee = currentUser() AND resolution = Unresolved)


4 answers

1 accepted

1 vote
Accepted answer

Since you are using OnDemand you have the possibility to get this data externally. Two choices which I would follow:

  1. Use one of the chrome plugins like tamper money and embed a small script which can get the REST data of the JQL (sample JQL here) and extract the issue-id of the parent task from the result
  2. Simple run a curl in the command line and parse the output of the same REST output

Great! I will try it.

if you are not on JIRA OnDemand you could use the script runner plugin. This has a jql function which can achieve this, see: https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-parentsOf%28Subquery%29

Thank you, but I'm using OnDemand now...

Is there an alternative way by using the original JQL function?

I'm afraid with standard JQL this is not possible.

1 vote
Andy Nguyen Atlassian Team Jan 03, 2014

Hi Shiwei,

As far as I know, there's no built-in JQL query that can help you to do so and the only way that I'm aware of is already recommended by Udo but unfortunately you're using OnDemand which does not support Script Runner.

At this stage I can only help you to raise a new feature request ticket in our JIRA forum but it may take time for the request to be addressed. Kindly let me know your opinion.



Hi, Andy

It seems I have to handle this case manually.

Anyway thanks for your reply!

Hope your team can help to implement the feature in near feature.



Hi, Andy

I will appreciate if you can help to add the feature to your feature queue.

Thanks a lot,


The below JQL can be used to filter the Stories which are in certain status based on the subtask status
issuefunction in subtasksOf("sprint in openSprints() AND issuetype = Story and status!= \"In Progress\"") AND project = "XY" AND statusCategory in ("In Progress")

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Wednesday in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

91 views 0 4
Read article

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