Groovy to compare 2 date fields

Raghu Ram_2tgcv1

The requirement is as below:

We have 3 fields - Outage Start Date, Change Start Date, Change End Date (all are Date Time picker fields). When someone tries to EDIT an issue, one should not be able to select an Outage Start Date that falls outside the Change window (which means Outage Start Data >= Change Start Date and Outage Start Date <= Change End date).

Can someone please provide a sample script to help. 

Antoine Berry

Hi @Raghu Ram , welcome to the community.

This is one script you can use with scriptrunner's behaviours : 

import com.onresolve.jira.groovy.user.FieldBehaviours
import groovy.transform.BaseScript

@BaseScript FieldBehaviours fieldBehaviours

int changeStartDate1Id = 11001
def changeStartDate = getFieldById("customfield_" + changeStartDateId)
def changeStartDateValue = changeStartDate.getValue()

int changeEndDateId = 11002
def changeEndDate = getFieldById("customfield_" + changeEndDateId)
def changeEndDateValue = changeEndDate.getValue()

int outageStartDateId = 11003
def outageStartDate = getFieldById("customfield_" + outageStartDateId)
def outageStartDateValue = outageStartDate.getValue()

if (outageStartDateValue != null && outageStartDateValue != ""){
if (changeStartDateValue != null && changeStartDateValue != "" && outageStartDateValue.compareTo(changeStartDateValue) < 0){
outageStartDate.setError("Outage start date can only be set after the change start date.")
}
else if (changeEndDateValue != null && changeEndDateValue != "" && outageStartDateValue.compareTo(changeEndDateValue) > 0){
outageStartDate.setError("Outage start date can only be set prior the change end date.")
}
}

Update the custom fields ids. You need to create a behaviour for each field.

Antoine