How to count subtasks in a story?

Koray Ekici
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 26, 2024

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

 

So , i need help please

4 answers

3 accepted

2 votes
Answer accepted
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 26, 2024

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:

number-of-sub-tasks-v2.gif

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

1 vote
Answer accepted
Charlotte Santos -Appfire-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2024

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! 😉

1 vote
Answer accepted
Sreenivasaraju P
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2024

Hi @Koray Ekici ,

 

Out of the box, it is not available. 

 

You can try workaround the same.

Koray Ekici
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 26, 2024

Thank you for the information. 

0 votes
Amay Purohit_RVS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2024

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

Links Hierarchy - Child Issue Types.PNG

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events