nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Count the number of subtasks in To Do status

simarpreet singh

Hi guys,

I need to find a way to count the number of subtasks under an epic which are in To Do status. Later on I'll use that count to run a post function which will based on the criteria that if count<10, then create a clone of subtask, else not.

I would prefer if we have a post function or condition there to do so. Not in favour of scriptrunner.

Thanks in advance

Accepted answers

Radhika Vijji _Innovalog_

Hi Simarpreet,

Look if you have Jira Misc Custom fields (https://innovalog.atlassian.net/wiki/x/6hp1C) of Innovalog in your instance. It provides Calculated fields that count the number of subtasks in a specific status on-the-fly.

Regards,

Radhika

Bibek_ikuTeam_

@simarpreet singh did you try using a JQL and get the count from there? You can take a note from https://community.atlassian.com/t5/Marketplace-Apps-Integrations/How-to-get-all-users-story-and-sub-tasks-under-user-story/qaq-p/272507

Too lazy to get all the content from there

-Bibek

All comments

Radhika Vijji _Innovalog_

Hi Simarpreet,

Regards,

Radhika

Bibek_ikuTeam_

Too lazy to get all the content from there

-Bibek

simarpreet singh

Hi @Bibek_ikuTeam_ - I already have JQL with me, but not going with that considering there are 14k issues to search for in JQL that can significantly affect the jira performance.

simarpreet singh

Hi @Radhika Vijji _Innovalog_ - It looks great. But I'm not able to find the exact code to have for calculating the number of tasks I have under epic which are in TO DO status right now! I would really really appreciate your help if you can specifically provide that code snippet.

Background:

There are 1400 epics, each representing a user. Each epic (or user) has 40 to 50 tasks. Now I want to rollup all the to do tasks, currently at the moment , to that specific epic.

Many thanks.

Radhika Vijji _Innovalog_

Sure Simarpreet. Where is your Jira hosted? Server or Cloud? JMCF is available for Jira Server only. Where you able to see Jira Misc Custom fields in your instance? If yes, this is what you might want to do:

Create a Calculated Number field, "Subtasks in To Do"
After creating the field, locate the field on the Custom fields page
Click on cogwheel for the custom field
Click on Configure
Click on Edit Groovy Formula
Input the following Groovy formula

issue.subtasks.findAll{it.status.name == "To Do"}.size()

Click on Save.
Since this applies to an issue of issue type "Epic" you can configure the custom field to be applicable to just the issues of issue type "Epic".
Perform a re-index as suggested by Jira.

Now on all the Epics, you will see the count of subtasks in "To Do" status under the Epic. You can also use these in searches on the Issue Navigator and statistics in the Gadgets.

Regards,

Radhika

simarpreet singh

Hi @Radhika Vijji _Innovalog_ Ma'm your solution seems really promising and I believe it is what I need! But I'm not able to locate groovy editor as you mentioned. See below:

Do I need to make any config changes?

*Also under epic, we have tasks and shift issue types. Shift is a custom issue type we created.

Thank you so so much

Thorsten Letschert _Decadis AG_

Hi @simarpreet singh ,

the matching expression for JWT is as simple as

count(filterByStatus(issuesUnderEpic(),"To Do"))

If you want to add it as a conditional execution to a post function, the expression could look like

count(filterByStatus(issuesUnderEpic(),"To Do")) < 10

Cheers
Thorsten

Serge DUDNIC

serious? it is so HARD to say how many todo tickets are ?

it is not the basic function of the JIRA to say what volume of work remain? should I learn the query language to have such a basic stat in a project?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software