aggregateExpression Σtimespent.sum

[Etienne Borella]

Hi

I use a lot scriptrunner jql function with aggregateexpression to sum estimates and time spent on the returned list of issues.

What I am trying to do now is to filter only parent issues, but sum the time spent of parent and their subatsks.

In other words, what currently works is :

project = KEY AND issuetype in standardIssueTypes() AND issueFunction in aggregateExpression("Total Original estimate", "originalEstimate.sum()", "Total time spent", "timespent.sum()")

But what I'd like to do is:

project = KEY AND issuetype in standardIssueTypes() AND issueFunction in aggregateExpression("Total Original estimate", "originalEstimate.sum()", "Total time spent", "Σtimespent.sum()")

 (same as the Σ Time Spent column we can see on the issue navigator list)

Is there a way to have that value?

Thanks for your help!

Etienne

[Hendrick Hassert]

Hi, it accepts "totaltimespent.sum()" but wrongly returns 0