I need the remaining value of two predefined custom filed values.

Ashok Barik

Hello there,
I am using Jira 8.4.x and need some assistance.

We have predefined the hour of matching value from fields 1 and 2.
For example, if I choose A from field1 and B from field2, the total hour is 60. (There are multiple total hours values according to the field1 and field2)

In my case, I want the remaining hour in the result if someone mentions his work hour in the filed3 then

Example:

Field1=A
Field2=B
(AB total hours = 60)
Field3 (My working hour) = 4
Remaining Hour I want = 60 - 4 = 56hr

 

Thank you in advance!

 

 

Sachin Dhamale_o1c5zi

@Ashok Barik ,

Welcome to the Atlassian Community.

1. First thing you will need script runner plugin for this

2. You need to create scripted field  and bellow script into it. Refer This Doc to know how to add script in scripted field 

3. In that scripted field you need to write script which will take values from field1 field2 and field 3 and will do calculation

= (field1*field2) - field3 and display the value in the scripted field

Here is the script 

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

def issueManager = ComponentAccessor.getIssueManager()
def linkManager = ComponentAccessor.getIssueLinkManager()
def cfm = ComponentAccessor.getCustomFieldManager()

Issue issueKey = issue
def id=issueKey.getId()

def customFieldManager = ComponentAccessor.getCustomFieldManager();

def cf = customFieldManager.getCustomFieldObject(id1) //field1 ID 
def cff = customFieldManager.getCustomFieldObject(id2) // field2 ID
def field3 = customFieldManager.getCustomFieldObject(id3) // field3 ID

def n = Integer.parseInt((issue.getCustomFieldValue(cf) ?: 0).toString().replaceAll(~/[.].*/, ""))
def b = Integer.parseInt((issue.getCustomFieldValue(cff) ?: 0).toString().replaceAll(~/[.].*/, ""))
def c = Integer.parseInt((issue.getCustomFieldValue(field3) ?: 0).toString().replaceAll(~/[.].*/, ""))

Integer remaining = (n*b) - c
return remaining

 

Accept the answer if it helps