Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JIRA JQL - Epic-Story-Subtask hierarchy

How can I get subtasks of Epic with certain status and component (without hard coding specific EPIC Keys).

I have Epic->Story->Subtask hierarchy 

I tried following functions without success

  1. IssueFunction in subtasksof("...")
  2. subtasksOf("IssueFunction in IssuesInEpics("...")
  3. LinkedIssuesOf options

What tool, plugin do I need?

3 answers

Hi @daljitsb -- Welcome to the Atlassian Community!

If you search the marketplace for JQL add-ons, you will find tools that could help with your request:

https://marketplace.atlassian.com/search?hosting=cloud&query=JQL

Depending upon the number of issues you expect back (and the number of epics), you could also use an automation rule to dynamically build the query, eliminating the need to hard-code the epic names.  Please look here for information about automation rules:

https://community.atlassian.com/t5/Automation-articles/Jira-Automation-all-the-resources-you-need-in-one-page/ba-p/1388465

Best regards,

Bill

Hi @daljitsb 

My understanding is you're looking to:

1) Select a JQL filter for Epics with a certain status or component.

2) See all Stories and Sub-tasks in the hierarchy underneath those Epics.

I created a plugin called Agile Docs which can do this.

Select your filter for Epics which matches your component or status criteria and Agile Docs will display all the issues underneath those Epics down to the sub-task level.

agile-docs-v2.png

Hope that helps!

Best Regards,

Rhys

0 votes
Rahul_RVS_Support Marketplace Partner Mar 12, 2021

Hi @daljitsb 

If you would be interested in a ready made solution, you may want to try out our add-on to manage multiple Epics and their hierarchy on a single page, with excel like editing of important fields.

Agile Tools - Epic Tree and Time in Status 

Manage and visualize your Epics with rolled up estimate progress reports.

Key features:

  • Epic Sum
  • Configure progress % calculation on either "remaining estimate" or "original estimates"
  • Epic Tree directly on Issue Screen
  • Display and manage Epics/Issues of your project
  • Real time edit option for Issue summary, status, time estimates, story points and assignee on the tree on the Epic Hierarchy
  • Rolled up percentage completion and at issue level as well
  • JQL support for Epic Hierarchy screen
  • Time in Status report using JQL
  • Issue Tracker to view complete transitions on your issue screen
    • Status Transition : View all the status changes in a single tab along with average time and count in each status. Switch between graphical and tabular view to make more out of the data.
    • Assignee Transition : View all the assignees for the issue along with the time for which the issue was with each assignee. Switch between graphical and tabular view to make more out of the data.

 

Epic Hierarchy Screen_Cloud_Edit.png

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you