Summation of aggregateExpression field values (Adaptivist ScriptRunner)

[Mikhail]

Hi guys,

I want to calculate story points number separately for Devs, SQAs and DevOps by JQL in quick filter. So, there are customfield_1 for total ticket estimation (dev+sqa or devops+sqa) and customfield_2 for SQA estimation only. Devops tickets are marked by DevOps label

Expression for Devs and SQAs works good:

sprint in openSprints() AND labels not in (DevOps) AND issueFunction in aggregateExpression("Total Story Points", "customfield_1.sum()", QA, "customfield_2.sum()", DEV, "customfield_()-customfield_2.sum()") OR sprint in openSprints() AND labels is empty AND issueFunction in aggregateExpression("Total Story Points", "customfield_1.sum()", QA, "customfield_2.sum()", DEV, "customfield_1.sum()-customfield_2.sum()")

However if I try to sum up story points for DevOps additionally , ScriptRunner will summarize all tickets in sprint despite the label value and won't show Dev value, because it's missed in last condition

sprint in openSprints() AND labels not in (DevOps) AND issueFunction in aggregateExpression("Total Story Points", "customfield_1.sum()", QA, "customfield_2.sum()", DEV, "customfield_()-customfield_2.sum()") OR sprint in openSprints() AND labels is empty AND issueFunction in aggregateExpression("Total Story Points", "customfield_1.sum()", QA, "customfield_2.sum()", DEV, "customfield_1.sum()-customfield_2.sum()") OR sprint in openSprints() AND labels in (DevOps) AND issueFunction in aggregateExpression("Total Story Points", "customfield_1.sum()", QA, "customfield_2.sum()", DevOps, "customfield_1.sum()-customfield_2.sum()")

Also I tried to add DevOps field to previous conditions with zero value but nothing changed

sprint in openSprints() AND labels not in (DevOps) AND issueFunction in aggregateExpression("Total Story Points", "customfield_1.sum()", QA, "customfield_2.sum()", DEV, "customfield_()-customfield_2.sum()", DevOps, "customfield_1.sum()-customfield_1.sum()") OR sprint in openSprints() AND labels is empty AND issueFunction in aggregateExpression("Total Story Points", "customfield_1.sum()", QA, "customfield_2.sum()", DEV, "customfield_1.sum()-customfield_2.sum()", DevOps, "customfield_1.sum()-customfield_1.sum()") OR sprint in openSprints() AND labels in (DevOps) AND issueFunction in aggregateExpression("Total Story Points", "customfield_1.sum()", QA, "customfield_2.sum()", DEV, "customfield_1.sum()-customfield_1.sum()"), DevOps, "customfield_1.sum()-customfield_2.sum()")

Do you know some hints for this Use Case? Thank you!

[Luis Tellado]

After updating to Scriptrunner DC 6.40.0 is seems that the Story Points sum has stopped working?

issueFunction in aggregateExpression("Total points", "StoryPoints.sum()")

Thanks! 

[Sylvain Leduc]

Indeed, that's why I came here !

So I just noticed they released a new v6.40.1 :)

https://docs.adaptavist.com/sr4js/6.40.1/release-notes/release-6-x#id-.Release6.xv6.40.1