nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Trying to add one year to a custom field value

Tom_51r9dj

Hi All,

Please can you advise:

I'm trying to create a script runner post-function to add one year to a field.

Have the below,

------------------------------------------------------------

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.CustomFieldManager

Issue issue = issue
def customFieldManager = ComponentAccessor.getCustomFieldManager()

// the dependent custom field
def dateACF = customFieldManager.getCustomFieldObjectByName("Forecast Date")

// get the value of the date A custom field
def dateAValue = issue.getCustomFieldValue(dateACF) as Date

// build the new date
def dateB = Calendar.getInstance()

// copy to the new date the value of the Date A custom field
dateB.setTime(dateAValue)

// add one year
dateB.add(Calendar.YEAR, 1)

//write back to custom field

issue.setCustomFieldValue(dateACF,dateB)

------------------------------------------------------------

This appears to validate OK in the Scriptrunner add on but when i try to execute the workflow transition i get the below error:

"Error occurred while creating issue. This could be due to a plugin being incompatible with this version of JIRA. For more details please consult the logs, and see: http://confluence.atlassian.com/x/3McB java.util.GregorianCalendar cannot be cast to java.util.Date"

Any advice would be appreciated.

Tom

Accepted answers

Tuncay Senturk _Snapbytes_

Hi @Tom

You can simply add 365 days as below

def dateB = dateAValue.plus(365)

All comments

Tuncay Senturk _Snapbytes_

Hi @Tom

You can simply add 365 days as below

def dateB = dateAValue.plus(365)

Tuncay Senturk _Snapbytes_

Or in your code you should convert GregorianCalendar to date

issue.setCustomFieldValue(dateACF,dateB.toInstant())

Tom_51r9dj

Thank you so much Tuncay. You are amazing! I've been struggling with this for a fortnight.

I can't believe someone on the Alsatian forum answered one of my questions with a succinct, rational answer and not developerspeak. I'm so Happy!

Tom_51r9dj

For the benefit of anyone else who is struggling with this and trawling the internet with despair;

------------------------------------------

//The below ScriptRunner post-function adds a specific number of days e.g. 365 to a custom field.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.CustomFieldManager

Issue issue = issue
def customFieldManager = ComponentAccessor.getCustomFieldManager()

//define the dependent custom field
def dateACF = customFieldManager.getCustomFieldObjectByName("CustomFieldName")

// get the value of the date A custom field
def dateAValue = issue.getCustomFieldValue(dateACF) as Date

// build the new date
def dateB = dateAValue.plus(365)

//write back to custom field
issue.setCustomFieldValue(dateACF,dateB)

Tuncay Senturk _Snapbytes_

I'm glad that it helped. Thanks for your kind words.

Tom_51r9dj

Hi, Sorry tried this one but does not work.

Using the code:

-------------------

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.CustomFieldManager

Issue issue = issue
def customFieldManager = ComponentAccessor.getCustomFieldManager()

// the dependent custom field
def dateACF = customFieldManager.getCustomFieldObjectByName("Forecast Date")

// get the value of the date A custom field
def dateAValue = issue.getCustomFieldValue(dateACF) as Date

// build the new date
def dateB = Calendar.getInstance()

// copy to the new date the value of the Date A custom field
dateB.setTime(dateAValue)

// add one year
dateB.add(Calendar.YEAR, 1)

// convert variable to correct type + write back to custom field
issue.setCustomFieldValue(dateACF,dateB.toInstant())

---------------

Generates the below error on the workflow transition:

http://confluence.atlassian.com/x/3McB java.time.Instant cannot be cast to java.util.Date

Tuncay Senturk _Snapbytes_

My bad, I think this should work

<span>issue.setCustomFieldValue(dateACF, </span>new Date(dateB.getTime()))

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server