The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Sum of Estimated time on Epics

Polina Krokhina
March 6, 2019

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 :(

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

1 vote
Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 6, 2019

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.

Polina Krokhina
March 6, 2019

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 :(

Screenshot_1.jpg