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 closed subtasks under an issue using smart values

Shamanth

Hi,

I am trying to update a custom field on the parent issue based on the number of subtasks using the JIRA automation. So far, I was able to count the number of subtasks under the issue using {{issue.subtasks.size}} which is working perfectly!

I would now want to count the subtasks that are "Closed" and update the count in the parent issue. What combination of the smart field works for this?

Accepted answers

All comments

jack brickey

Hi @Shamanth , welcome to the community.

See if you can work the following into your rule. Please note that the last action is simply a means of logging the value for test purposes. I'm unsure exactly what your action plans are such as email.

Shamanth

Hello Jack,

Thanks for responding!

Let me explain about the 1st automation rule that I have successfully created. In this rule, I will be counting the total number of subtasks under the parent issue and update that number to a custom field named 'Total Findings' of the parent issue.

Now I would like to replace the smart value {{issue.subtasks.size}} with another smart value that can count the number of subtasks with status=Closed. How can I achieve that?

Also, I tried replicating your rule, but unfortunately I could not find the Lookup Issues function.

jack brickey

You can take what I gave you before and simply make your action be to edit the field of the parent with the smartvalue that I showed in the log action.

Shamanth

I am sure that your solution would work, but I am currently on JIRA v8.20 and this lookup function is still not available to me. I am waiting for my organization to deploy the upgrade after testing.

Any alternative solution you might be aware of?

Bill Sheboy

Hi @Shamanth

First thing, I am using Jira Cloud and not Server/Data Center.

As Jack notes, your version does not have Lookup Issues, so perhaps try the bulk-handling features with a JQL branch, and then use the {{issues}} smart value. Note that one is plural to handle the issues as a set.

Please look here to learn about that feature: https://confluence.atlassian.com/automation/run-a-rule-against-issues-in-bulk-993924653.html

Kind regards,
Bill

Vinod Kotiya

This is how I done by merging both solution. I am doing batch automation on 1000s of issues and its sub-tasks.

I got total subtask using {{issue.subtasks.size}}

and number of done after lookup {{lookupIssues.size|0}}

Sara Grab

Hi @Vinod Kotiya , I have a question related to this if you can help me please. I have subtasks issue type called "Story defects". I want to count the total number of story defects under each story in a numerical custom field I created called "Story defects Number". I've tried this rule attached but it didn't work, can you please guide me here on what is needed?

Thanks in advance.

Screenshot 2024-11-19 at 8.38.58 PM.png

Bill Sheboy

Hi @Sara Grab -- Welcome to the Atlassian Community!

As this is a very old thread, I recommend creating a new question, and perhaps linking back to this one. That will ensure the maximum number of people see it to offer suggestions.

Until we see your new question...

The JQL you use for the Lookup Issues action will find ALL issues with a type of "Story Defect". You probably want to find only the ones which have the same parent issue:

parent= {{issue.key}} AND issueType= "Story Defect"

Kind regards,
Bill

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server