How do I filter to see all subtasks in a project for a given parent issue type?

My Jira project has 4 issue types (e.g. Product Specification), and 3 subtask types (e.g. PMO Task). Any of the 4 issue types can contain zero or more of any of the subtask types.

I'd like to create a filter to see all the subtasks of a given (subtask type, parent issue type) tuple.

E.g. I may want to see all the "PMO Task"s that have ever been created for "Product Specification"s (thus filtering out all the "PMO Task"s that have been created for, e.g. "Development Deliverable" parent tasks.

How do I do that?

5 answers

1 accepted

1 vote
Joe Wai Tye Atlassian Team Jun 16, 2014

Hey Johan,

Currently, it is not available inside JIRA. However, I have raised a JIRA request for this, which you can find here - JRA-38798

I would recommend that you do the following on the feature request ticket :

  • Vote, so that it will receive more attention
  • Watch it, so that you will receive any and all updates
  • Comment, and give your opinion on the matter

Please note that the implementation of new features and improvement requests falls under Atlassian's Implementation of New Features Policy.

Thanks! Done.

Hi,

You may use the ScriptRunner Plugin.

issueFunction in subtasksOf("sub query here returns all parent tasks")

But disclaimer says it will be paid plugin soon.

Another option thats already paid plugin is :

https://marketplace.atlassian.com/plugins/org.craftforge.jira.craftforge-jql-functions-plugin

Vijay

Thanks Vijay, practically how do I do that - do I just copy & paste the code you quoted into the JQL field? Or does issueFunction stand for something I need to fill in? It looks like a promising approach. I work in a midsize corporate, so don't control the plugins that are allowed, but it may already be installed.

To expands - this should be:

issueFunction in subtasksOf("issuetype = MyParentType") and issuetype = MySubTaskType

So the first clause will find all the subtasks of the particular parent type you care about, then filter further to the subtask type you care about.

Yes, you paste than in the advanced JQL editor.

> But disclaimer says it will be paid plugin soon.

True, but it's said that for around 2 years now.

Hi Johan,

This is from Script runner plugin. Can you check with JIRA Admin if it is installed?

Vijay

Thanks! Unfortunately I get this: "Field 'issueFunction' does not exist or you do not have permission to view it." Which I suspect means my company hasn't got that plugin installed.

Hi Johan,

NOTE: This post is purely my personal opinion and not an objective comparison of the plugins :-)

If you are to convince someone about a plugin solving your described issue I personally would recommend the ScriptRunner!

Two reasons actually:

  • It is still free and I have the feeling that it will stay this way, at least for the core functions. Maybe i am wrong but even if it turns into a paid plugin it will be worth it because of my second reason
  • The ScriptRunner is a Swiss army-knife! It has so many great functions and I use it more or less all the time. As a JIRA consultant it is the first thing I look for with a new customer. I don't understand how to live without it. It makes my day so much easier.

The two other plugins mentioned are also good plugins. I have used them both with great result but they are not just as versatile as the ScriptRunner.

Cheers,

// Svante

Liked the bit with Swiss army-Knife :) Sure Script runner is THE plugin I use the most as an administrator of JIRA right now. That was the reason I placed as first option.

The closest I have come is an advanced filter with JQL that references the "parent" field, but that is a dead end because that field only contains the unique key of the parent task, not its type. Unless there's some way to look up the type based on the key (in a subquery), and then filter on that?

0 vote

Another option is JQL Tricks plugin (Paid). See http://www.j-tricks.com/jqlt-subtask-functions.html

Thanks! Unfortunately we don't seem to have that plugin installed. Working at a corporate, I don't have control over this aspect of Jira config.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

141 views 4 6
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