Getting Tempo billable hours for issue in a ScriptRunner scripted field

Alex Fox_gv1ddv

Has anyone ever achieved this? I'm hoping for some Groovy examples of calculating billable hours for an issue. The one example I found is several years old (https://community.atlassian.com/t5/Jira-questions/Show-tempo-field-quot-Billed-quot-hours-in-jira-issues/qaq-p/71917) and seems to retrieve all logged time, regardless of whether it's billable or not.

Appreciate any insights!

Bram V

Had the same requirement so I did invest some hours to figure out how. The following code allows you to get the attribute from Tempo called BILLABLE_SECONDS. I however noticed that when billable time (which is automatically copied from getTimeSpent during creation of the worklog) is not altered and kept identical, the code below will return a null for BILLABLE_SECONDS. So it seems that this value is not filled during creation if the value is the same as time spent. This is however NOT wat you would expect and something you do not want. Especially since when these values are not the same during creation or are altered and set to the same afterwards, the BILLABLE_SECONDS attribute does get set.

Current workaround that works for me: If the attribute BILLABLE_SECONDS returns null, set it to the same value as getTimeSpent() since this value is probably caused by the bug.

 

import org.apache.log4j.Level
import org.apache.log4j.Logger

def log = Logger.getLogger("com.onresolve.scriptrunner.runner.CLITest")
log.setLevel(Level.DEBUG)

import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.issue.worklog.Worklog;
import com.atlassian.jira.component.ComponentAccessor

import com.onresolve.scriptrunner.runner.customisers.PluginModule
import com.onresolve.scriptrunner.runner.customisers.WithPlugin
import com.tempoplugin.core.workattribute.api.WorkAttributeValueService
import com.tempoplugin.core.workattribute.api.WorkAttributeService

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

@PluginModule
WorkAttributeService workAttributeService

@PluginModule
WorkAttributeValueService workAttributeValueService

def issueManager = ComponentAccessor.getIssueManager()
Issue issue = issueManager.getIssueObject(“PROJECTKEY-XXX")

for (Worklog worklog : ComponentAccessor.getWorklogManager().getByIssue(issue)) {
    def attributeBillableSeconds = workAttributeService.getWorkAttributeByKey("BILLABLE_SECONDS").returnedValue
    def workAttributeValue = workAttributeValueService.getWorkAttributeValueByWorklogAndWorkAttribute(worklog.id, attributeBillableSeconds.id)
    def billableseconds = workAttributeValue.returnedValue
    if (billableseconds == null) {
        billableseconds = worklog.getTimeSpent()
    }
    log.debug("Billableseconds: " + billableseconds?.value)
    log.debug("getTimespent: " + worklog.getTimeSpent())
}