I want to sum up the previous value and the current update value of a custom field and display the r

Question

I want to sum up the previous value and the current update value of a custom field and display the result in another field. For example:I have two fields: field1 (Money spent) and field2 (Total spent). If I add a number in  field1 then it should sum up with the previous value of it and then display the result in the Total spent field. Details:Jira Software - 8.4.3ScriptRunner available = yes

Martin Bayer _MoroSystems_ s_r_o__ · Answer

Hi @Ashok Barik , followint script is working for me :)

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.ModifiedValue
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.onresolve.scriptrunner.runner.customisers.PluginModule
import com.onresolve.scriptrunner.runner.customisers.WithPlugin

def issue = event.issue

def loggedInUser = ComponentAccessor.jiraAuthenticationContext.loggedInUser
def change = event.changeLog.getRelated("ChildChangeItem")?.find { it.field == "Money spent" }

// a field other than the Account field updated, nothing to do here
if (!change) {
return
}

def customFieldManager = ComponentAccessor.customFieldManager
def moneySpentField = customFieldManager.getCustomFieldObjects(issue).find { it.name == "Money spent" }
def totalSpentField = customFieldManager.getCustomFieldObjects(issue).find { it.name == "Total spent" }

def moneySpent = issue.getCustomFieldValue(moneySpentField) as Double
moneySpent = moneySpent ?: 0

def totalSpent = issue.getCustomFieldValue(totalSpentField) as Double
totalSpent = totalSpent ?: 0

totalSpentField.updateValue(null, issue, new ModifiedValue(issue.getCustomFieldValue(totalSpentField), totalSpent + moneySpent), new DefaultIssueChangeHolder())

Ashok Barik · Answer

Hi @Martin Bayer _MoroSystems_ s_r_o__

I am new to the script runner and am not a programmer. It would be greatly appreciated if you could provide me with the script. I appreciate your valuable time and all your support.

Ashok Barik · Answer

Hi @Martin Bayer _MoroSystems_ s_r_o__ Thanks a lot for providing me with all details.

I used this script in the Script Runner field but it didn't work, can it work in Listener?

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.issue.IssueManager;
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.link.IssueLinkManager
import com.atlassian.jira.user.ApplicationUser

Issue issueKey = issue
def id=issueKey.getId()
def customFieldManager = ComponentAccessor.getCustomFieldManager();
def cff = customFieldManager.getCustomFieldObjectByName("Money Spent")
def b = Integer.parseInt((issue.getCustomFieldValue(cff) ?: 0).toString().replaceAll(~/[.].*/, ""))

def changeHistoryManager = com.atlassian.jira.component.ComponentAccessor.getChangeHistoryManager()
def old = changeHistoryManager.getChangeItemsForField(issue, 'Total Spent')
def d = 0;
if (old != null) {
Integer sum = b + d
return sum
}
else {
def cf = customFieldManager.getCustomFieldObjectByName("Total Spent")
def n = Integer.parseInt((issue.getCustomFieldValue(cf) ?: 0).toString().replaceAll(~/[.].*/, ""))
Integer sum = n + b

}