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; } } }

Searching for subtasks of parents that meet certain criteria

Allan Chow

I have quite a bit of subtask cleanup that I need to do. I'd like to find all subtasks of Parent Issues that are in the closed state. I was hoping to do something along the lines of:

parent in (status = closed)

or even

parent in (filter = closedIssuesFilter)

Is something like this possible? What would be the best way to accomplish this?

Accepted answers

Piotr Polak1

You can also use Script Runner plugin and a query like:

issueFunction in subtasksOf("project = XXX AND issuetype = Task AND status = Closed")

All comments

Allan Chow

Found the answer over on stackoverflow:

http://stackoverflow.com/questions/5153024/filter-to-show-sub-tasks-of-a-filtered-list-of-parent-tasks

There's a pretty neat plugin, Craftforge: https://plugins.atlassian.com/plugins/org.craftforge.jira.craftforge-jql-functions-plugin

Per Gradeen1

Issue nav.

- > Configure Columns

-> add subtasks

Copy all. subtasks

Paste in advanced search

key in (Sub-1, Sub2...)

Search...

But maybe u can start by selecting done issues and see subtask...

Piotr Polak1

You can also use Script Runner plugin and a query like:

issueFunction in subtasksOf("project = XXX AND issuetype = Task AND status = Closed")

M. P.

I don't know whether it's still relevant, but we had same problem and it was solved with help of following plugins:

- Query Issue Custom Field delivers validators, that can be checked also for status etc.

- AM Utils delivers opportunities search for parents/subtask and create JQL inside another one, like

issue in issueParents("project = AAA")
issue in issueSubtasks("project = AAA")

Maybe it can help

Hassan Saleem

There is no need for any Plugin..

Switch to "advance" filter option and enter

status in ("Open") AND parent in (PHX-xxx,ENG-xxx)

It will give you all the open tickets present as a subtask in parent JIRAS. Build more complex and enjoy using JIRA. Advance filter options will also give you all possible values to build Queries.

Please comment if its helpful.

Regards.

Hassan Saleem

Quality Control Engineer

Wellogic. U.A.E

Jennifer Kenemer

Hassan, I'm trying your solution but I'm getting error "The issue key 'CP' for field 'parent' is invalid." CP is our project key. What am I doing wrong?

Rade Martinović

Not really good suggestion as a filter like this would work only at one point in time. I need "search for parents with condition" for my Agile board.

Linda Schmandt

Jennifer, are you using the full issue number in 'parent'? It has to be CP-1234 (or whatever)

Enelar

It is paid version. What the point.
We unable to create board with sub-issues (filtered by version, epic, component). When you click at issue, and looking into subtask, what you see? Hided by filter.

Atlassian knows and forcing us to pay more. I do not know why it still isn't in the box.
They sells product with several flaws, half-stuffed. I think they starving of good competition.

Enelar

AM Utils great, but outdated

Rade Martinović

Hey Kirill,

I have ScriptRunner version 3.1.4 installed, which is free. You can install it manually. I don't have the need for subtasks anymore, but if you find ScriptRunner useful I think that you should at least try it out.

Ben Richman

Can anyone help? I am using the latest version of Script runner and when running the above JQL to search for sub tasks i get this error:

Error in scripted function: subtasksOf, see below
com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException

Suzanne Seaton

I had the following request:Is there a way to search for subtasks of change requests?

Here is the JQL for that:

issueFunction in subtasksOf(" issuetype = 'Change Request' ") AND category =

"Client Service Desk Projects"

Charles Porter2

Would really like to be able to query for all issues and their sub-tasks in (for instance) an Epic.

All the answers here require either multiple manual step, hard coded Issue ID's or a plugin. Can't use the suggested plugin in Cloud Jira.

It is surprising and disappointing that something this basic is hard or impossible in the JIRA query language

gcarignano

I found this free add-on, tried it and it works for retrieving subtasks.

https://marketplace.atlassian.com/apps/1211565/am-utils?hosting=server&tab=overview&_ga=2.70885081.833645198.1548066667-1246393927.1497272413

Dennis Gerads

That's only available if you are using Jira Server. What can be used with the Web version?

Nikita Breikin

linkedIssue in linkedIssues("ISS-111")

Preethi Ramesh_cmpu4u

I was trying to exclude all subtasks from a specific parent key and used the below query. Worked for me.

assignee in (<jira usernames>) AND status not in (Closed, Done, Complete, Resolved, Cancelled) AND project not in (<give project names that you would like to exclude>) AND parent != <which ever parent key you would like to exclude>

This query removed all the subtasks for the parent key

justez

Dan Knapton

No longer free

Francisco Correa_emox15

If you happened to filter for Issues under an Epic, and you have subtasks/defects under your Issues, you can use parentEpic

In my case, issue AB-1234 is the Id of the Epic under which all issues and their subs are hierarchically organized

project = AB AND "Epic Link" = AB-1234 OR parentEpic = AB-1234 ORDER BY Rank ASC

Then all issues of the EPIC and all their subtasks show and can be displayed using Swim-lines

Note that the subs do not have to have the EPIC identified as they take it from the parentEpic

Lee-Ann COSTA

Thank you !!!! I've been looking for help with this for a while and this query finally worked for me!

Daniel Brvnišťan_m8r5gv

Hi Francisco,

Is there any way to modify the query so it would return all issues under all Epics that are in certain project (not the project of issues, but of Epics).

Something like:
"Epic Link" contains "AB-"

We have Epics that are cross-projects (if that's a good practice is a valid question, but not now please ).

Thanks!
Daniel

Susan Escalona-Sauro

That didn't work for me but this did. Pulled up all the tasks, stories and subtasks in an EPIC. I've been looking for this answer for months!!!

parentEpic = dev-1422

Joris Vleminckx

parentEpic does the trick!

Viet Cao Hoai

Yes. No longer free

Andreas Lärkfeldt_63xji9

LOL - WHY do everybody keep using "hardcoded" issue keys (like KEY-1234). You should never use "hardcoded" keys! Period!

So did someone actually find a solution for Jira Cloud in this matter?
(where we DONT need to update issue keys manually)

Sorry - but this isn't the only thread I've seen "people trying to help, but who doesnt".

Kind regards

Andreas

Paige_lr1e16

I am using v8.5.9 and get the following when I try to use parentEpic..

"Field 'parentEpic' does not exist or you do not have permission to view it."

No idea if this is a versioning issue, or if my company admins have locked that field down... I am admin of my project in Jira, but we have company level Jira administrators too

Paige_lr1e16

parentEpic has worked for some, but it doesn't work for me...

I am using v8.5.9 and get the following when I try to use parentEpic..

"Field 'parentEpic' does not exist or you do not have permission to view it."

No idea if this is a versioning issue, or if my company admins have locked that field down... I am admin of my project in Jira, but we have company level Jira administrators too

Josh Elias

Why hasn't Atlassian implemented this feature yet?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

sub-task