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 Reporting based on Subtask status


I would like to generate a report that should give me the data as 

Parent task -->  sub task items --> Status 

  • My user story A1 has B1,B2,B3,B4 sub tasks
  • B1 -is working progress
  • B2 is completed
  • B3 is onhold B4 Review

How can achieve this report?


2 answers

1 accepted

2 votes
Answer accepted

Hi @Sanjay Venkata Kameswara Akondi ,

I am afraid that you could get not these results with the native JIRA features. JQL does not behave like SQL. It returns issues based on conditions and does not provide a view or combined results. 

You can use a JQL like this issueFunction in subtasksOf("key=A-1") that will list all sub-tasks of A-1 with their status. 

issueFunction in subtasksOf("type=Story") will return sub-tasks whose parent is of type Story. 

Thanks, Niranjan. Currently, that is how I am using it. I wanted to know any other ways to handle this situation for the bulk of the tasks.

Like Niranjan likes this

HI @Sanjay Venkata Kameswara Akondi 

If you would be interested in a ready made solution, You may want to try out our plugin,

Agile Tools : Epic Tree & Time in Status 

The plugin provides complete hierarchy of your issues with their statuses and much more. Our Links hierarchy module allows you to include subtasks in your hierarchy. Which I believe will suffice your requirement.

Along with this the add-on also provides Epic Hierarchy, Multiple (more than 8) Time in Status reports to track your issues and Worklogs report to track time spent each day/week/month, based multiple filters/group


Links Hierarchy.png

You can find all subtasks of a specific issue with this JQL:

parent in (ABC-1,ABC-2)

You can also get all subtasks of issues that match a query with our app:

After you install the app you can simply search:

issue in subtasksOfParentsInQuery("type=Story") and type=Story

to get the full list of stories and their substasks.

Make sure to check out the docs as well.

I hope this solution is helpful to you and others!

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

940 views 2 22
Read article

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