nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Johan10

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?

Accepted answers

Theinvisibleman

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.

All comments

Johan10

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?

Vijay Khacharia

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

Jobin Kuruvilla [Adaptavist]

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

Theinvisibleman

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.

Johan10

Thanks! Done.

Johan10

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.

Johan10

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.

Svante Gustafsson Björkegren

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

JamieA

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.

JamieA

> But disclaimer says it will be paid plugin soon.

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

Svante Gustafsson Björkegren

I have voted also!

Vijay Khacharia

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.