Hello!
It seems that the date calculation has a small error. You can use this script in ScriptRunner to compare the field of type "datepicker" with the current date. The script checks if the field date is less than 60 days from the current date and automatically transitions
I hope it serves as a guide for you
import java.time.LocalDate
import java.time.format.DateTimeFormatter
import groovy.json.JsonSlurper
def issueKey = "TEST-1"
def issueResponse = get("/rest/api/3/issue/${issueKey}?fields=customfield_10015")
.header('Content-Type', 'application/json')
.asString()
if (issueResponse.status == 200) {
def issueData = new JsonSlurper().parseText(issueResponse.body)
def datePickerField = issueData.fields.customfield_10015
// Define the current date and date formatter
def currentDate = LocalDate.now()
def formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd")
// Parse the date from the Date Picker field
if (datePickerField) {
def parsedDate = LocalDate.parse(datePickerField as String, formatter)
def daysDifference = java.time.temporal.ChronoUnit.DAYS.between(parsedDate, currentDate)
// Check if the date is less than 60 days from today
if (daysDifference <= 60) {
logger.info("The date is within 60 days. Transitioning issue...")
// Perform the transition
def transitionResponse = post("/rest/api/3/issue/${issueKey}/transitions")
.header('Content-Type', 'application/json')
.body([
transition: [
id: "21" // Replace with the ID of the transition you want to perform
]
])
.asString()
if (transitionResponse.status == 204) {
logger.info("Transition successful.")
} else {
logger.error("Failed to transition the issue. Response: ${transitionResponse.status}")
}
} else {
logger.info("The date is more than 60 days ago. No transition performed.")
}
} else {
logger.error("Date Picker field is empty.")
}
} else {
logger.error("Failed to retrieve issue details. Response: ${issueResponse.status}")
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.