Update a date custom field considering the Due Date populated date

[Neenu jose]

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-2019	01/01/2020	31/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-2019	05/01/2020	10/11/2019

[Antoine Berry]

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]

hi @Neenu jose ,

Did that work for you ?