Sum of Estimated time on Epics

Question

Good evening everyone!

Faced a problem, unable to create a valid groovy request in the script runner. I need to create a field in the epic, which would contain all the information about the clock in the related issues. Scheduled hours logged and remaining hours.
ScriptRunner often writes "No such property: issue for class: Script68", never managed to create a request that would satisfy the plugin.

I found the perfect query jql "project = TEST and assignee = currentUser () and issueFunction in aggregateExpression (" Total Estimate for All Issues "," originalEstimate.sum () "," Remaining work "," remainingEstimate.sum () "," Time spent for all issues "," timespent.sum () ")"
It displays the necessary information, but I can’t understand how to add a groovy query to it :(

Polina Krokhina · Answer

Thank you for your comment, but i already tried this two options. I wpuld like to write a query by myself.  After writing your second query in scriptrunner, there became an error.

I've connected to my Linux machine to find some logges with explaining why therre is an error, but didn't find :(

Petter Gonçalves · Answer

Hello Polina,

Welcome to Atlassian community!

Just a suggestion: There is a free plugin that sums the time estimation of related issues in the Epic without needing any code:

- Epic Sum Up - Light

Using Scrptrunner, you can use the script documented in the link below, except use "Epic-Story Link" instead of the example given ("Composition")

Work Remaining In Linked Issues

Let me know if one of the options above worked for you.