Update a date custom field considering the Due Date populated date

Neenu jose November 18, 2019

Hi Team,

 

We have a requirement to update a custom filed "Due Date Provided On" with the date on which "Due Date" field is populated.

Below is the actual requirement, how can we implement this?

 

Case“Due Date” field in JIRA“Due Date Provided On” field in JIRA
XYZ-123 is created with no Due Date<empty><empty>
User A adds the Due Date of 1-Jan-2020 to XYZ-123 on the 31-Oct-201901/01/202031/10/2019
User B deletes the Due Date on the 5-Nov-2019<empty>31/10/2019
User A adds the new Due Date of 5-Jan-2020 to XYZ-123 on the 10-Nov-201905/01/202010/11/2019

1 answer

Suggest an answer

Log in or Sign up to answer
0 votes
Antoine Berry
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 20, 2019

Hi @Neenu jose ,

Here is a script you can use for your need : 

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.ModifiedValue
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder

import java.sql.Timestamp

def dueDateChanged = event?.getChangeLog()?.getRelated("ChildChangeItem")?.find {it.field == "duedate"}

if (issue.getDueDate() != null){
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def dueDateProvidedOnId = 12500
def dueDateProvidedOn = customFieldManager.getCustomFieldObject(dueDateProvidedOnId)
def dueDateProvidedOnValue = issue.getCustomFieldValue(dueDateProvidedOn)

dueDateProvidedOn.updateValue(null, issue, new ModifiedValue(dueDateProvidedOnValue, new Timestamp(new Date().getTime())), new DefaultIssueChangeHolder())
}

Use a script listener on the "Issue Updated" event, and any additional event where you are likely to change the due date.

Also add a script post function in the create transition, use this script while removing this line :

def dueDateChanged = event?.getChangeLog()?.getRelated("ChildChangeItem")?.find {it.field == "duedate"}

Let me know if that helped.

Antoine

Antoine Berry
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 22, 2019

hi @Neenu jose ,

Did that work for you ?

TAGS
AUG Leaders

Atlassian Community Events