Scripted post function to set a date value in custom field

Alex Christensen Community Champion May 12, 2015

I want to set a custom date field using a post function, but I only want to capture the current date if the field has not yet been set. I'd use a regular post function to do this, but once this field is populated, I don't want it to get overwritten, which is why I've turned to a script for this. I'm very new to groovy scripting and don't have much of a coding background - here's my attempt after looking at a lot of resources here on Answers and elsewhere.

import java.util.*
import com.atlassian.jira.ComponentManager
import com.atlassian.jira.CustomFieldManager
import com.atlassian.jira.issue.Issue

def customFieldManager = ComponentManager.getInstance().getCustomFieldManager()
def date = new Date()
Issue issue = issue
def funcDate = issue.getCustomFieldValue( customFieldManager.getCustomFieldObjectByName("Ready for Func Test") ) 

if (!funcDate) // if this field is empty, then the current date is set for this field
	issue.setCustomFieldValue("Ready for Func Test", date)

Basically, we want to be able to report on the date in which the issue was first transitioned to a particular status. I don't want to overwrite the value if the same transition is used again (which is very possible in our workflow setup). I've tried several variations of the code above, but I can't seem to get it to work the way I want it to. Even if the field is empty, the field does not get a value set to it during the transition for which I've configured this post function.

Is what I'm trying to do possible via a scripted post function? Am I at least close? smile Thanks for your help in advance!

2 answers

1 accepted

2 votes
Answer accepted
Alex Christensen Community Champion May 14, 2015

Found my answer using the answer in from a previous question here. Here's the final script I used:

import com.atlassian.jira.ComponentManager
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.fields.CustomField
import static java.lang.Math.*
import java.sql.Timestamp

// get current issue
Issue issue = issue
customFieldManager = ComponentManager.getInstance().getCustomFieldManager()


// Getting custom field value
cfFuncDate = issue.getCustomFieldValue( customFieldManager.getCustomFieldObjectByName("Ready for Func Test") )


// Getting custom field object
cfoFuncDate = customFieldManager.getCustomFieldObjectByName("Ready for Func Test")


// get today's date
today = new java.sql.Timestamp(new Date().getTime())


// set value
if (!cfFuncDate)
	issue.setCustomFieldValue(cfoFuncDate, today)

hello 
@Alex Christensen will this run in JIRA cloud too?

Alex Christensen Community Champion Aug 23, 2018

I don't believe that it will. I don't have a Cloud instance to test this, but I don't think ScriptRunner on Jira Cloud allows you to configure scripted workflow post-functions.

The above code gives me errors in the scripting window as soon as I paste it in - non declared variable, missing method and some other static review errors. I'm sure it is close but I'm very new to that language and the libraries/methods available.

Is there a working version of code to put today's date into a date field if it is empty?

@Dave Furlani this should probably work for you and stop throwing those non-declared variable errors.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.fields.CustomField
import java.sql.Timestamp

def customFieldManager = ComponentAccessor.getCustomFieldManager()

// Getting custom field object
def cfoFuncDate = customFieldManager.getCustomFieldObjectByName("Ready for Func Test")

// Getting custom field value
def cfFuncDate = issue.getCustomFieldValue(cfoFuncDate)

// get today's date
def today = new java.sql.Timestamp(new Date().getTime())

// set value
if (!cfFuncDate) {
issue.setCustomFieldValue(cfoFuncDate, today)

Thanks, but I get a static check error on line 1 saying unable to resolve class com.atlassian.jira.ComponentAccessor.

The script could not be compiled: <pre>org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: Script86.groovy: 1: unable to resolve class com.atlassian.jira.ComponentAccessor @ line 1, column 1. import com.atlassian.jira.ComponentAccessor ^ 1 error </pre>.

That's the only error though, which is an improvement on the script in the earlier posts.

So close.

Alex Christensen Community Champion Feb 20, 2019

Oops, my bad. I fixed the script in my last post and it should no longer throw that error. :)

Thanks Alex, that version worked perfectly.

You are a champ.

Slight alteration:

def cfFuncDate = customFieldManager.getCustomFieldObjectByName("Ready for Func Test")
def funcDate = issue.getCustomFieldValue(cfFuncDate)
if (!funcDate) // if this field is empty, then the current date is set for this field
    issue.setCustomFieldValue(cfFuncDate, date)

 

 

Alex Christensen Community Champion May 12, 2015

Hi, Jamie - thanks for your help! Unfortunately, I made this alteration and the field still isn't populating. I double checked the name of the custom field to make sure I wasn't going crazy, too. :) Is there anything I need to do with the date format? JIRA presents the date as DD/MM/YY - if that's an issue from how Date() pulls the current date, how can I alter my code to populate the date in this format? Also, just to test, I took out my if statement to see if anything would write to that custom field anyway - I got the same result as before. The field is still empty.

Where is the post-function in the list of post-functions? If towards the top, it should work. Can you find your atlassian-jira.log and see if there are any errors...

Hi @Jamie Echlin [Adaptavist] ,

I have a Date Picker Field. I need a script to validate the Date which is <=now. If date is greater throw an exception

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 14, 2019 in Jira

Updates to jira.atlassian.com give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

758 views 1 17
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you