Automation story point estimate - sum of story points of child items in parent field

[Pedro Henrique Barreto Carvalho]

Hello,

I have a question.

I would like to create an automation that whenever I update the fields (story point) in the subtasks, the story point estimate field (story point field/Parent) is updated with the sum of the points informed in all the subtasks.
I did the automation below, but the field is not being updated.

thanks

[Bill Sheboy]

Hi @Pedro Henrique Barreto Carvalho 

Ignoring for a moment the practice of using story points with subtasks rather than just with stories...

Your estimated points field edit is on the Parent issue, but you are trying to:

• reference the trigger issue, which is a subtask, and
• using an invalid mathematical structure by adding to smart values without wrapping them with {{#=}} your smart values {{/}}

Instead you could just update the parent by summing the results each time in the branch with:

{{issue.subtasks.Story point estimate.sum|0}}

Please note this will work for a team-managed project, which uses Story point estimate.  If this is instead for a company-managed project, use Story points.

Kind regards,
Bill

[Pedro Henrique Barreto Carvalho]

Hello @Bill Sheboy 

thanks for the feedback. I have a project managed by the team. I tried to apply the code, but the field in the parent story(Sory point estimated) was not updated

[Bill Sheboy]

For your smart value expression in the edit, it seems you changed the name.  Perhaps try the exact built-in field name to see if that works.  

{{issue.subtasks.Story point estimate.sum|0}}

I wondered about that as your trigger also shows "Story point estimate" and not the one you typed in as "Story point estimado".

[Pedro Henrique Barreto Carvalho]

Thanks for the feedback. I received the points return by email, but the field: story estimated points was not updated.
Do I need to do this update via code (more options)? Would you help me?

[Bill Sheboy]

You seem to be using a custom field named "estimated points", and so when you copy/paste that smart value expression into the edit value, it will appear below the field...then you may select it and it will be used.

If instead you want to update the parent issue's actual "Story point estimate" field, that can only be done with JSON under "more options".

Which do you want to do?

[Pedro Henrique Barreto Carvalho]

Hi @Bill Sheboy 

I would like to do it for Json. Can you help me?

[Bill Sheboy]

First, here is the documentation on using JSON for the edits and I encourage you to review it as it can help identify problems and provides how-to ideas: https://support.atlassian.com/cloud-automation/docs/advanced-field-editing-using-json/

For updating Story point estimate in the parent for the sum of the children, please try:

{
  "fields": {
    "Story point estimate": "{{issue.subtasks.Story point estimate.sum|0}}"
  }
}

[Pedro Henrique Barreto Carvalho]

Thanks for support

I managed to solve it with the code below

{
"update": {
"Story Point estimate" : [{
"set": {{issue.subtasks.Story point estimate.sum|0}}
}]
}
}