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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

daljitsb I'm New Here Mar 10, 2021

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?

2 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 

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