Scheduled Sum of Subtasks to Tasks

[Amanda TAY]

Dear All, 

Thank you in advance. Does anyone know how to schedule the summing of subtasks to tasks on a daily basis? I do not need it per change, but I do want it to run on a daily basis to look for all subtasks and then sum it up and replace the task story points. 

Right now I have the "component may be incompatible" error. 

Thank you!

AT

[Trudy Claspill]

Hello @Amanda TAY 

You are getting the warning because branching to a related issue (the Parent issue) requires that your rule already have an issue in focus. The Lookup Issues action retrieved a list of issues but does not put the rule focus on any of the retrieved issues.

You can add a JQL to your Schedule trigger to select issues that would be parents of subtasks.

That puts those issues in focus for the rule. The remainder of the rule components will run for each issue retrieved by the trigger.

The second step would be to use a Lookup Issues action to retrieve the subtask for the issues from the trigger using the JQL 

Parent ={{issue.key}} and issuetype = Sub-task

Next I would add a smart value Condition to check that the Lookup actually retrieved issues:

{{lookupIssues.size|0}} is greater than 0

Then follow that with an Edit Issue action. This will apply to the Parent issues found by the JQL in the trigger.

In this action you can choose the Story Points field from the "Choose fields" pull down. In the accompanying entry field you can type in the smart value {{lookupIssues.Story Points.sum}}

[Amanda TAY]

Hi Trudy, 

Thank you! I have tried to put what you mentioned into the automation, but i didnt really get the part about the adding of the smart value connection to check that the Lookup works. 

Here is what i have set up now, is it on the right track?

[Stephen_Lugton]

Hi @Amanda TAY 

Rather than looking at subtasks and pushing story points up to Parents, why not try it the other way round?

In your schedule JQL try something like:

Project = MyProject and Type = Task and statuscategory != Done

Then for your next condition use IF {{smartvalues}} condition

{{issues.subtask.size}}

does not equal

0

and finally Edit Issues

Story Points

=

{{issue.subtasks.Story points.sum}}

[Stephen_Lugton]

[Stephen_Lugton]

You don't even need the IF statement, without it all that happens is that the task story points is set to 0 rather than none

[Vishal Biyani]

@Amanda TAY 

With Scheduled, you will have to specify the JQL. Since there is no issue trigger, you are getting the error in the way lookup is being used.

Note that there is a limit to number of rows that can be handled via JQL.

• What is the reason you are not going for field update trigger?
• what is the business reason to have Story points updated at subtask level instead of Story/task level?

[Amanda TAY]

Hi! Thank you. Too many automations, and we just don't need feedback that quickly. Why at subtask, because of how the team does their planning today, where they have a tendency to breakdown the tasks to subtasks when they have the visibility on what they need to do. It is not the best practice, but it is what works for the team.