Count number of 'Defect-Task' under Parent and add to custom field 'Defect Count' to Parent

Question

We created a NEW subtask called 'defect-task' for our projects so users can now differentiate between a sub-task or defect-task under an issue.  However, we would like have a count under the parent of the number of defect-tasks.  Using automation, I was able to count the total number of subtasks under any given parent using {{issue.subtasks.size}} but the result also includes sub-task counts.

Bill Sheboy · Answer

Certainly, and...using automation rules is often about experimentation and learning.  There really isn't anything in documentation that covers every scenario.

Let's try Lookup Issues...In your rule, it appears to be triggered on one of your Defect-tasks.  And so you could find all siblings with JQL such as this:

project = {{triggerIssue.project}} AND parent = {{triggerIssue.parent}} AND issueType = Defect-task

Using that with the Lookup Issues action would gather them, and then the count would be:

I added a default value of 0 just in case there are none.

Richard Romero_pdcwpd · Answer

Thanks Bill... Great resources but can you be more specific on how to resolve my particular problem with examples?

Bill Sheboy · Answer

Hi @Richard Romero

You can do that either using Lookup Issues with a JQL filter or with smart value, list filtering and a math operation.  Here are some references to help you try those methods:

* https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues
* https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588
* https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

Kind regards,
Bill