Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Scripted post function to set a date value in custom field

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

4 votes
Answer accepted

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?

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.

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.

Thanks a lot for sharing this script! It was exactly what I was looking for and it worked on the first try!

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)

 

 

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 @JamieA ,

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
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you