How can I view all issues and sub-issues of a single sprint in basic filter?

[Preeti Rajasekharan]

Hi Team,

I would like to create a dashboard which shows me all the (issues + child issues), assignees and statuses of 1 sprint in a particular project.

I am able to create a basic filter which shows me all issues in the sprint. I would also like to see all the child issues as well as the issues in that sprint. 

Please help.

[Trudy Claspill · Accepted solution]

Hello @Preeti Rajasekharan 

With native Jira functionality to get the subtasks of an issue you use the filter:

parent=<issue key of parent>

If you want to get the child issues of multiple issues you use the filter:

parent in (<comma separated list of issue keys of parent issues>)

What you want is the ability to get the child issues based on another filter that selects the parent issues, like this:

parent in (sprint=<your sprint>)

That is not currently possible with native Jira functionality.

It is possible with the addition of certain third party apps. Are you willing to get a third party app to satisfy your requirement?

[Preeti Rajasekharan]

Hi Trudy,

Thank you for your response. 

parent in (<comma separated list of issue keys of parent issues>)  -  this seems a lil complicated as i will have to then each time keep adding issue numbers into the actual filter itself.

Third party apps - again depends and it may involve additional costs which I cannot approve myself. But what are those apps? I'd be happy to go thru them anyways and explore a bit.

[Trudy Claspill]

There likely would be additional cost for use of a third party app.

You would want to look at apps that extend JQL capabilities. Here is an appropriate Atlassian Marketplace search to get you started.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=jql

One that I have used before is Adaptavist's ScriptRunner app. With that you would use a filter like:

sprint = <your sprint> or issueFunction in subtasksOf("sprint=<your sprint>")

(Note: I am not affiliated with Adaptavist and get no compensation for suggesting their app. I'm just a fan of it.)

There are other apps in the search results above that provide the same kind of functionality.

[Danut M _StonikByte_ · Accepted solution]

Hi @Preeti Rajasekharan,

You best option here is the Work Break-Down Chart gadget offered by our Great Gadgets app. 

This gadget displays the issues from a filter in a tree structure according to their hierarchy: Epic > Tasks, Stories > Sub-Tasks along with their status, giving you a quick overview of the work's content and progress.

If you already have a filter that returns the issues to be displayed, all you have to do is to configure this gadget to use this filter. 

This app offers many other gadgets for Scrum, Kanban, SAFe, Service Desk projects. To make a better idea, have a look over the articles from our blog. It can be a great asset for your team or company.

I hope this helps.

Thank you,

Danut.

[Preeti Rajasekharan]

Thank you Danut for your response. Appreciate it. I will look into it.

[Hannes Obweger - JXL for Jira]

Hi @Preeti Rajasekharan

if you're open to solutions from the Atlassian Marketplace, I think you'd really like the app that my team and I are working on, JXL for Jira.

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 number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This is how it looks in action:

As every sheet is powered by a JQL statement, you can very easily build a sheet that represents your current sprint.

Any questions just let me know,

Best,

Hannes

[Pradeep]

Hi @Preeti Rajasekharan 

You can try out the app we have built for the same use case.

Issue Hierarchy  

You can view / create complete hierarchy of multiple issues in place.

The app is free upto 10 users. Do try it out.

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