Scriptrunner for Jira cloud - Diference between datetime custom fields

José Matheus Neto

All i wanna do is compare 2 custom datetime fields and show the difference in a custom numeric field (in hours if possible)

 

The closest i got is here:

 

import java.time.LocalDate
import java.time.LocalDateTime;

import static java.time.temporal.ChronoUnit.MINUTES

def reqagreeddate = LocalDateTime.parse(issue.fields.customfield_10029)
def resolutionDate = LocalDateTime.parse(issue.fields.customfield_10032)
def dateDifference = MINUTES.between(reqagreeddate, resolutionDate)

issueInput.fields.customfield_10031 = dateDifference

 

but i got the following ERROR 

2019-10-25 18:37:53.523 ERROR - Text '2019-10-25T00:00:00.000-0300' could not be parsed, unparsed text found at index 23

 

 

I resolved this by giving up and using an project automation plugin for jira called Automation for jira... Scriptrunner still very poor for cloud version in my opinion. With this new tool i was able to do all i wanted in less than 2h.

 

Kristian Walker _Adaptavist_

Hi Jose,

Thank you for your question.

I can confirm that the code suggested above will not work for Jira Cloud due to the fact that the code you have provided is foo ScriptRunner for Jira Server and this will not work as Atlassian only provide a rest API in Jira Cloud and do not provide a Java API in the cloud like they do in Jira Server.

You can see more detailed information on the differences between the cloud and server versions inside of our documentation page located here.

I can confirm that to create a calculated field that calculates the value of two custom fields and stores the value inside a third custom field with ScriptRunner for Jira Cloud that you should use a Script Listener which is configured to fire on the Issue Updated event. 

Finally, I can confirm that we have an example Script Listener script located in the documentation page here which shows how to create a calculated field and I can confirm that this should be used as a reference guide to help create the script which you require.

Kind Regards,

Kristian