Scripted custom field for Σ Remaining Estimate

[Kelly LaMar]

Hi folks,

I need a scripted field that adds up the remaining time estimates of the subtasks. I know JIRA does this automatically on the parent issues but I need that "Σ remaining estimate" value in an explicit field so I can export those values to our project management tool. I have ScriptRunner, we're on the server.

I assume I'll then need to create a listener that triggers a re-index on the parent issue when subtasks are edited, but I can do that separately.

I'm not a developer and I can't figure out what specific script I need to make this work - any help would be greatly appreciated!

Thanks,

Kelly

[Kelly LaMar · Accepted solution]

Thanks to Vasiliy Zverev I now have this script that does what I need - thanks for pointing me to those other threads!

import com.atlassian.jira.issue.Issue

long totalSum = 0;
for(Issue subtask: issue.getSubTaskObjects()){
 if(subtask.getEstimate() != null)
 totalSum += subtask.getEstimate()
}

return totalSum / 60

[Kelly LaMar]

FWIW for future folks: I ended up tweaking the code so it now adds remaining estimates of all the subtasks as well as the remaining estimate on the story level ticket, or returns null if neither story nor subtasks have estimates. Final code below:

import com.atlassian.jira.issue.Issue

long totalSum = 0;
boolean noEstimates = true;
def totalSubTasks = issue.getSubTaskObjects().size()

for(Issue subtask: issue.getSubTaskObjects()){
 if(subtask.getEstimate() != null){
 totalSum += subtask.getEstimate()
 noEstimates = false
 }
}
if (issue.getEstimate() != null){
 totalSum += issue.getEstimate()
 noEstimates = false
} 

if (noEstimates == true){
 return null
}
else {
 return totalSum / 60
}

[Bastian Stehmann]

Hi @Kelly LaMar,

Maybe one of this questions is similar to yours.

https://community.atlassian.com/t5/Questions/Sum-of-custom-field-values-from-subtasks-in-parent-issue-custom/qaq-p/132517

https://community.atlassian.com/t5/Jira-questions/Scriptrunner-Scripted-field-to-sum-fields-of-child-tasks/qaq-p/879628

https://community.atlassian.com/t5/Jira-Software-questions/Sum-up-fields-in-sub-tasks-and-show-the-result-in-story/qaq-p/681309

https://community.atlassian.com/t5/Jira-questions/Sum-of-OriginalEstimation-of-Task-and-his-subtasks-estimation-in/qaq-p/275284