Subtract Two Time Stamps

[Fahad Ahmad]

I just started using the script runner for subtracting my custom field and created datetime

I am getting the values of both fields successfuly but i need to subtract them to get the difference. I am unable to subtract since both are in string format. there values are as mentioned below.

2018-12-26T15:12:00.000+0300 custom
2018-12-06T12:59:25.203+0300 issue

I have tried getTime() with them and as Date as well but no success. 

def issueKey = 'SD-9'
def customFieldName = 'customfield_10009'
def issueCreatedKey = 'created'

def result = get("/rest/api/2/issue/${issueKey}")
.header('Content-Type', 'application/json')
.asObject(Map)
if (result.status == 200) {
def custom = result.body.fields[customFieldName]
def issue = result.body.fields[issueCreatedKey]
return custom - issue
} else {
return "Error retrieving issue ${result}"
}

[Thanos Batagiannis [Adaptavist] · Accepted solution]

Hi Thu,

Try a custom script post-function like 

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.user.ApplicationUser

def issue = issue as MutableIssue

def cf = ComponentAccessor.customFieldManager.getCustomFieldObjectByName("UserPicker")
def cfValue = issue.getCustomFieldValue(cf) as ApplicationUser

if (cfValue) {
    issue.setReporter(cfValue)
}
else {
    log.debug "Did not update the reporter because value of UserPicker field was null"
}

Please let me know if this does the trick.

regards, Thanos

[Thu Trần Aroma]

Thank you for your support.

It works like magic!

[Edward Greathouse]

This script is similar to what I want to do, except I want to set the reporter to a specific user depending if the custom field value equals 'Support'. Here is what I have:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.user.ApplicationUser

def issue = issue as MutableIssue

def cf = ComponentAccessor.customFieldManager.getCustomFieldObjectByName("Origin")
def cfValue = issue.getCustomFieldValue(cf)

if (cfValue == 'Support') {
 issue.setReporter('sthomson@ivansinsurance.com')
}
else {
 log.debug "Did not update the reporter because custom field value was null"
}

However, I get the following error on the "setReporter()" line:

com.atlassian.jira.issue.MutableIssue#setReporter(java.lang.String). Please check if the declared type is right and if the method exists.

Any help would be greatly appreciated!

[Edward Greathouse]

*Additional Info*

The script will run, but it is not logging the string, nor is it setting the reporter.

[Nina Zolotova]

@Thanos Batagiannis [Adaptavist], thank you, your script helped me a lot!