Summarizing points from specific types of children on parent

[Derek Knudsen]

We use custom subtasks to gather front end and back end developer effort (story points) related to a parent ticket.  I want to create automation so that when story points of these issues types are changed that the values are (re)summed in the corresponding field on the parent.  So for example for my "FE Sub-task" child type, if a FE Sub-task is added to a Story and it's Story Points set then automation would update the field "FE Story Points" on the parent.  This is straightforward to do for all subtasks with Smart Values -  {{issue.subtasks.Story Points.sum}} - but I don't know how to do this for specific types of subtasks.  Can you do it with Smart Values? 

[Kalyan Sattaluri · Accepted solution]

Hello @Derek Knudsen 

There are many ways to solve this. One way is to use lookupIssues.

After your trigger, do lookupIssues with

JQL = parent = {{issue.key}} and issuetype IN ("FE Sub-task" , "BE SubTask")   for example.

Then you can get sum as {{lookupIssues.Story Points.sum}} which you can use to update your fields.

Another way is to use conditional logic in smart values to filter for your issue types of interest..

Both achieve the same result Hope it helps and if stuck, please share screenshot of the rule. Thanks!

[Derek Knudsen]

@Kalyan Sattaluri this worked great!  Thanks for the help!