Calculate the sum of all values of a Custom Field in linked issues

Add together multiple custom field values from linked issues and display the total in a ScriptRunner Scripted field.

  • Template: Number Field
  • Search Template: Number Searcher

Requirements

Jira Jira (7.3 - 7.13)

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue

// the issue type for which we want the scripted field to be displayed
final String issueTypeName = "Bug"

// the linked issues with that issue type will used
final String linkedIssueType = "Support"

// the values of that custom field - of type number - we want to sum up
final String customFieldName = "Number of Users"

if (issue.issueType.name != issueTypeName) {
    return null
}

def linkedIssues = ComponentAccessor.issueLinkManager.getOutwardLinks(issue.id).findAll { it.destinationObject.issueType.name == linkedIssueType }
if (!linkedIssues) {
    return null
}

def customField = ComponentAccessor.customFieldManager.getCustomFieldObjects(linkedIssues.first().destinationObject).findByName(customFieldName)
if (!customField) {
    log.debug "Custom field is not configured for that context"
    return null
}

linkedIssues*.destinationObject.sum {  Issue it -> it.getCustomFieldValue(customField) ?: 0 }
Discovered an issue? Report it here

Suggested for you

Appears in these Collections