JQL: How to retrieve all sub-tasks for multiple stories that are child issues of an Epic

[Sven]

Hello!

I was wondering if their was an easy way to write a JQL to retrieve sub-tasks for multiple stories that are child issues of an Epic?

E.g. 

Epic 1

   User Story 1

      Sub Task A

      Sub Task B

   User Story 2

      Sub Task C

Best

Sven

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Sven

just to clarify, do you really want to retrieve only the sub-tasks (and don't care about the "User story" level in between), or would you prefer to see the actual "issue hierarchy" below your epic? 

If it's the former, you're probably best off with one of the Marketplace apps that extend JQL by additional functions, including hierarchy-related capabilities. I've used JQL Search Extensions and it works great.

If it's the latter, there are also various options available. If you're on Jira Premium, you may want to have a look at Advanced Roadmaps. Alternatively, there are many hierarchy-focused apps available on the Marketplace. I myself happen to work on such an app, in which this would be trivial to do; I'll provide more information below.

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the last point, this is how this would look in the app that my team and I are working on, JXL for Jira:

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a range of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, and conditional formatting.

Any questions just let me know!

[Sven]

Hi @Hannes Obweger - JXL for Jira Thanks for the reply. yes I only wanted to retrieve the sub tasks and not user stories in this scenario so it sounds like I need extend JQL. Thanks again. Best Sven

[Rahul_RVS]

Hi @Sven 

With plain JQL, this view is not available.

If you are open for a mktplace solution, we have built an app for the same use case.

Issue Hierarchy Reports 

Through this app you can visualize your complete hierarchy including linked issues and much more. Do Try it out.

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

[Sven]

Thanks @Rahul_RVS 

[Danut M _StonikByte_]

Hi @Sven,

Grouping by epic is not possible in JQL. 

But you could try the Work Breakdown Structure (WBS) dashboard gadget offered by our Great Gadgets app.  It does the grouping for you and displays the issues from a filter in form of Epic > Stories, Tasks > Subtaks along with their status, exactly as you want.

All you have to do is to create a filter that returns all the issues to be grouped, and to configure the gadget to use this filter. 

This app offers many other gadgets that you might find useful. 

If you have questions, please do not hesitate to contact us at support@stonikbyte.com.

Thank you,

Danut M. 

[Sven]

Many thanks @Danut M _StonikByte_ . Its great to see these add-ons exists for problems that exists! Best Sven