Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL to find out Epic->Story/Task->Subtask

gajanan_sasane
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 3, 2022

Hello All,
I want to find out the all issues under Epic all Stories/Tasks, Stories/Tasks under all Subtask in one JQL.

Thanks in advance.

5 answers

1 accepted

2 votes
Answer accepted
Jack Brickey
Community Champion
November 3, 2022

Hi @gajanan_sasane , welcome to the Community. Unfortunately, OOTB, you cannot retrieve the subtasks associated with epics since they are indirectly associated thru the stories/tasks. There are many addon solutions and you may have one of these already in your instance. This is a frequently asked question in the Community so I encourage you to seek posts with the various solutions.

Jack Brickey
Community Champion
November 3, 2022

I should add that if you were to add a label to all subtasks when created then you could retrieve. For example...

"epic link" = xxx or labels = epic-xxx

Like John Funk likes this
0 votes
John Funk
Community Champion
July 7, 2023

Hi @gajanan_sasane  - I am marking Jack's answer as Accepted. Please let us know if you still have questions about this. 

0 votes
Madhu_RVS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 7, 2022

Hi @gajanan_sasane 

Welcome to the community !!

If you are fine with a mktplace app, to get this data, you can try out our plugin. 
It is available for Jira Server.

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

You can view/mange your complete hierarchy through the app and add it as a gadget in the dashboard as well.

Disclaimer : I am part of the team which developed this app

Epic Hierarchy.PNG

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
November 7, 2022

Hi @gajanan_sasane

welcome to the community!

Just to add to the above answers: If want to see your issues in their actual hierarchy - i.e., with children nested under their parents - you may want to have a look at Advanced Roadmaps - this being said, I'm not entirely sure if AR is available for Jira Server these days.

Alternatively, there's a number of hierarchy-focused apps on the Atlassian Marketplace that can do that for you. As an example, I myself work on an app named JXL for Jira, in which this is really just a matter of a single click:

hierarchy.gif

With this, you could now inline-edit, sort, or filter your issues (much like you would in e.g. Excel or Google Sheets), apply advanced features such as conditional formatting, or export to CSV or Excel.

(Please note that while JXL is not listed for Server on the Marketplace, it is perfectly compatible with Server; it's just that we need to create a license for you. If you're interested, just let me know and I'll create a free trial for you.)

Hope this helps,

Best,

Hannes

0 votes
mauricio.groth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 3, 2022

Hi @gajanan_sasane

As you're on Jira Server, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

We have a few functions that could help you with your request.

  • You can use this function to find subtasks of parents.
issue in subtaskOf("")
  • You can use this function to find the parents of subtasks
issue in parentOf("")
  • You can use this function to search for all epics, issues in epics, and subtasks of these issues. 
issue in allIssuesInEpic("")
  • You can use this function to find all epics
issue in epicOf("")

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

Suggest an answer

Log in or Sign up to answer