Jira Automation - smart values - sync story points

[christophe demez]

Hi,

I'm trying to create an automation rule that for each Epic, it sums all the story-points of the child stories.

I have follow this tutorial (second one):
https://community.atlassian.com/t5/Automation-articles/Jira-Automation-Sum-Up-Story-Points-Roundup-Initiatives-gt-Epics/ba-p/1928027

And then I have this:

But the story points remain empty. Do you have any idea ?

thx

[Mark Segall]

Hi @christophe demez 

You're close, but you need a Lookup Issues action.  Additionally, you should tweak the query to reduce overhead.  I recommend this:

• TRIGGER: Scheduled (Daily)

  • Project = "Service Portfolio" AND issueType = Epic and statusCategory != Done

• ACTION: Lookup Issues

  • "Epic Link" = {{issue}}

• ACTION: Edit Issue (Story Points)

  • {{lookupIssues.Story Points.sum}}

[christophe demez]

Thanks @Mark Segall , you're right. I just noticed that I'm not on the cloud for this instance. So, there is no "lookup issue"... so not sure I can solve this problem.  Any idea ?

I have try the following... but no way:

[Mark Segall]

Ahh server is definitely more complicated.  I found this poking around the internet:

https://medium.com/javarevisited/jira-automation-sum-story-points-in-epic-9626b8c1c23c

[christophe demez]

Indeed, it is more complex, but I cannot set anything on the stories, because they are from other projects. I do not have the permissions :-P Not sure there is a solution :-(

[Mark Segall]

Yeah you'd need a Jira Admin to elevate the rule to a global rule.

[christophe demez]

I have try with smart values, I use this: {{issue.issueLinks.outwardIssue.Story Points.sum}}

Then, it sum the list of linked stories, but I need the list of Epic's stories.

[Mark Segall]

Yes - This is the core issue.  Without the Lookup Issues function, the only way to dynamically evaluate against epics would be what I shared earlier.