How to count subtasks in a story?

[Koray Ekici]

I want to display story list in dashboard which have more than 3 sub-task in a story. 

So , i need help please

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Koray Ekici

in native Jira, the easiest would probably be to use Jira Automation to write the number of subtasks into a custom field, and then use the custom field to query your issues.

If you're open to solutions from the Atlassian Marketplace, you'll find more options there; e.g., my team and I work on an app in which your use case would be easy to solve: 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 so-called smart columns that aren’t natively available, including the number of subtasks.

This is how it looks in action:

As you can see above, you can easily sort and filter by the number of subtasks, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all just works, so there's no scripting whatsoever required.

Any questions just let me know,

Best,

Hannes

[Charlotte Santos -Appfire- · Accepted solution]

Hi @Koray Ekici 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to list stories which have more than 3 sub-tasks:

type = story and subtasksCount >= 3

Please contact our support if you have any other questions about this query.

We’ll be happy to help you! 😉

[Sreenivasaraju P · Accepted solution]

Hi @Koray Ekici ,

Out of the box, it is not available. 

You can try workaround the same.

• You can have no of subtask field and Using automation you can increment the same on subtask creation.
• You can try with scripting field, which will return number of subtask.
• You can try with third party plugins like JQL Search Extensions  https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-reports?hosting=cloud&tab=overview

[Koray Ekici]

Thank you for the information. 

[Amay Purohit_RVS]

Hi @Koray Ekici 

Welcome to the community !!

As suggested by others a custom solution can help you view subtasks count. If you would like to try out a mktplace app for your requirement, please take a look at an add-one have developed for the same use case.

Issue Hierarchy 

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