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 to get subtasks of an EPIC in a filter query?

Paulo Costa_cz4g56

Hi all,

I'm sort of new with JIRA and I am trying to get a board that shows me all work related to an Epic. We are using Epics, Stories and Subtasks of the stories.

My query looks something like

project = CXT AND "Epic Link" = CXT-2120

This way I am not able to display the subtasks on my filter/board.

The alternative would be to use tasks and then manually link them to the Story and to the Epic, which is additional admin work.

Is there something I am missing or is there anyway I can get the subtasks to show in the filter/board?

Thanks in advance.

Accepted answers

Trudy P Claspill

HI @Paulo Costa

Welcome to the community.

This works in JIRA Cloud. Try it on your system.

project = CXT AND (issuetype = Story AND "Epic Link" IN (CXT-2120)) OR (issuetype = sub-task AND "parentEpic" IN (CXT-2120))

If it works, credit goes to Mark Klein for the answer in this post.

https://community.atlassian.com/t5/Jira-Software-questions/JQL-to-show-all-issues-AND-subtasks-in-the-Epic/qaq-p/346433

Jack Nolddor [Sweet Bananas]

Hi,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack (if you are on Server / DataCenter) you can type the following:

0) The Epic itself

key = CXT-2120

1) Subtask created directly on Epic

issue IN subtasksOf(' key = CXT-2120 ')

2) Find all tasks (Tasks, Stories,...) under a given Epic (i.e. CXT-2120)

"Epic Link" = CXT-2120

3) Find all subtasks under returned issues above

issue IN subtasksOf(' "Epic Link" = CXT-2120 ')

4) All together (Epic, Tasks & Subtask)

key = CXT-2120 OR "Epic Link" = CXT-2120 OR issue IN subtasksOf(' key = CXT-2120 OR "Epic Link" = CXT-2120 ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

Regards

All comments

Trudy P Claspill

HI @Paulo Costa

Welcome to the community.

This works in JIRA Cloud. Try it on your system.

project = CXT AND (issuetype = Story AND "Epic Link" IN (CXT-2120)) OR (issuetype = sub-task AND "parentEpic" IN (CXT-2120))

If it works, credit goes to Mark Klein for the answer in this post.

https://community.atlassian.com/t5/Jira-Software-questions/JQL-to-show-all-issues-AND-subtasks-in-the-Epic/qaq-p/346433

Italo Qualisoni [e-Core]

@Trudy P Claspill ,

Cool information, I didn't know until now that parentEpic existed!

parentEpic - Search for issues and sub-tasks that are linked to an epic.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearching-functionsreference-parentepicparentEpic()

Paulo Costa_cz4g56

Thanks @Trudy P Claspill , I have tried and still does not work. I've read the post you shared and also @Italo Qualisoni [e-Core] shared link, and as we are using JIRA Server, looks like we have to buy some add-ins.

If by any chance you have any other ideas I would appreciate.

Trudy P Claspill

Adaptavist Scriptrunner is a powerful app that extends JQL search functionality, plus provides many other features. I used it at my previous employer and really liked it.

If that offers more than you want and you are looking for something less expensive, check the Similar Apps links at the bottom of its marketplace page to see if any of those can help with extensions for searching.

Jack Nolddor [Sweet Bananas]

Hi,

0) The Epic itself

key = CXT-2120

1) Subtask created directly on Epic

issue IN subtasksOf(' key = CXT-2120 ')

2) Find all tasks (Tasks, Stories,...) under a given Epic (i.e. CXT-2120)

"Epic Link" = CXT-2120

3) Find all subtasks under returned issues above

issue IN subtasksOf(' "Epic Link" = CXT-2120 ')

4) All together (Epic, Tasks & Subtask)

key = CXT-2120 OR "Epic Link" = CXT-2120 OR issue IN subtasksOf(' key = CXT-2120 OR "Epic Link" = CXT-2120 ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

Regards

Paul Matteucci

@Paulo Costa

I realise it's a year later, but there's a command called "epicParent" that does just this:

parentEpic = EPIC-1

parentEpic in (EPIC-1, EPIC-2)

I hope this helps.

Cheers

Hector Meurice

Thank you Paul, it actually worked!

Alexander Agneessens

Alternative solution:

I was facing the same issue I was looking for an answer too!
But I found a solution without the need of any additional Jira add-ons.

So if you want to have all stories & the sub-tasks of these stories in one JQL filter, you have to refer in your JQL filter to a structure.

So first create your structure e.g. "STRUCTURE_X"
In your structure you use as JQL query to insert all stories linked to that epic:
issue in linkedIssues("epic-1234") or ("Epic Link" = epic-1234)

Now you have a structure with all the stories linked to the epic.
What is still missing are the "subtasks"
So in your structure, you add -> Extend > Subtasks...

Now you have a structure with all stories and all subtasks connected to these stories.
So the structure results in Epic > Story > Subtasks

Now you go back to your quick filter:
and add the following JQL query: issue in structure("STRUCTURE_X")

=> That's how I was able to solve it on my end.. Hope it helps..

Florencia Pocetti

Hi @Alexander Agneessens i'm trying to follow your guideline, is it possible to copy paste the SQL filter you used?
I'm not quite sure I've sure I've followed the Structure Step

Alexander Agneessens

Hi @Flore the JQL is quiet specific to your project
but you could just enter the following as JQL:
issue in linkedIssues("epic-1234") or ("Epic Link" = epic-1234)

Press "Automation" > Insert > JQL querry
And than you just enter as JQL:

issue in linkedIssues("epic-1234") or ("Epic Link" = epic-1234)
-> With the issue keys for you project.

But maybe share what you would like to obtain as a result, that will allow me to give better feedback..
Or do you get an error when you follow my steps ? Or where do you get stuck?

Alex R_

Unfortunately, epicParent does not appear to be a native field.

Cal Hoffman

I'm with Florencia here - I'm trying to follow, but you haven't indicated how to define a structure. Can you give an example of what the full JQL would look like, including setting up and then implementing the structure?

Joviano DIas

This is what worked for me without needing any add-ons.

All items including subtasks contained in the EPIC

issue in childIssuesOf("epic-2191")

Only subtasks of the epic

 issue in childIssuesOf("epic-2191") and issuetype in subTaskIssueTypes()

Not subtasks

 issue in childIssuesOf("epic-2191") and issuetype not in subTaskIssueTypes()

Jawad Newaj

Thank you so much for this simple and effective solution! This has worked for my problem!

Matt Libby

If this were StackOverflow, I'd say, "This should be the accepted answer."

Not just an accepted answer, but the accepted answer.

++++

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server

atl-gruland

quick-filter