I would like to generate a report that should give me the data as
Parent task --> sub task items --> Status
How can achieve this report?
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.
If you would be interested in a ready made solution, You may want to try out our plugin,
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
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!
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...
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