Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to calculate sum of tempo work attributes?

Thu Trần Aroma September 6, 2017

I use tempo timesheets and add a work attribute called 'Data1' as numberic.

I want to build a script field that will sum all the values of Data1 that are logged on this issue.

I have found an example to work with tempo work attributes here

https://scriptrunner.adaptavist.com/latest/jira/plugins/working-with-tempo.html#_summing_worklogs_with_an_attribute

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.worklog.Worklog
import com.onresolve.scriptrunner.runner.customisers.PluginModule
import com.onresolve.scriptrunner.runner.customisers.WithPlugin
import com.tempoplugin.core.workattribute.api.WorkAttributeService
import com.tempoplugin.core.workattribute.api.WorkAttributeValueService

@WithPlugin("is.origo.jira.tempo-plugin")

@PluginModule
WorkAttributeService workAttributeService

@PluginModule
WorkAttributeValueService workAttributeValueService

def worklogManager = ComponentAccessor.getWorklogManager()
def worklogs = worklogManager.getByIssue(issue)
def overtimeLogs = worklogs.findAll { worklog ->
    def attribute = workAttributeService.getWorkAttributeByKey("_Overtime_").returnedValue
workAttributeValueService.getWorkAttributeValueByWorklogAndWorkAttribute(worklog.id, attribute.id).returnedValue
}

overtimeLogs.sum { Worklog worklog ->
    worklog.timeSpent
} as Long

The script works but it returns the sum of timespent, not the sum of Data1. I am really not sure how to get the attribute values in order to sum them up.

Can you help me with this problem, please?

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events