ScriptRunner Listener: Get sprint end date and set it as due date of the issue

Reno_pdzcjo

Hello,

What I am trying to do is simple, and I had a partial success following other posts but not yet completely.

I want to create a ScriptRunner Listener custom script that executes every time an issue is updated, if the issue is associated with a sprint, take its end date and set it as the due date of the issue.

So far I achieved to get the code to set the due date of the issue, but I need to get the sprint end date in  "dd/MMM/aa" format to work with this code (according to the documentation of the method here):

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.user.ApplicationUser
import com.atlassian.jira.bc.issue.IssueService

def loggedInUser = ComponentAccessor.jiraAuthenticationContext.loggedInUser
def issue = event.issue
IssueService issueService = ComponentAccessor.getIssueService()

// Get sprint end date
def SprintEndDate = ¿?¿?¿?

// Set Due Date
def issueInputParameters = issueService.newIssueInputParameters()
issueInputParameters.setDueDate(SprintEndDate)

def updateValidationResult = issueService.validateUpdate(loggedInUser, issue.id, issueInputParameters)
if (updateValidationResult.isValid()) {
// Validate the update
def issueResult = issueService.update(loggedInUser, updateValidationResult)
} 

 I also got the part to get the Sprint End Date like this:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.atlassian.jira.issue.ModifiedValue
import java.sql.Timestamp;

def customFieldManager = ComponentAccessor.getCustomFieldManager()
def sprint = customFieldManager.getCustomFieldObjectByName("Sprint")

//End Date
Date endDate = event.issue.getCustomFieldValue(sprint)?.endDate?.first()?.toDate()

But I am having trouble merging both parts.

Can anyone help me?

Thank you so much in advance.

PD Sheehan

Have a look at this script that combines both concepts along with an additional trick of only running when the change contains an actual update to the sprint field.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.event.issue.IssueEvent
import com.atlassian.greenhopper.service.sprint.Sprint
import com.onresolve.scriptrunner.runner.customisers.WithPlugin
@WithPlugin("com.pyxis.greenhopper.jira")

def issueService = ComponentAccessor.issueService
def loggedInUser = ComponentAccessor.jiraAuthenticationContext.loggedInUser
def event = event as IssueEvent //re-cast to help with static checking error in the Script Editor. Don't need this if you edit your script in line
def issue = event.issue

def changeItems = ComponentAccessor.changeHistoryManager.getChangeHistoryById(event.changeLog.id as Long).changeItemBeans
if (!changeItems.any { it.field == 'Sprint' }) {
//skip this listener if the sprint field wasn't changed
    return
}

def sprintCf = ComponentAccessor.customFieldManager.getCustomFieldObjectsByName("Sprint")[0]
//get the current list of sprints on the issue
def sprints = issue.getCustomFieldValue(sprintCf) as List<Sprint>
if (!sprints) {
//if sprint field is empty, the change was to delete the last remaining sprint on the issue.
    // You might choose to clear the due date here
    return
}

//using last sprint. If there are more than one, the last one is most likely to be active the others should be closed
def sprint = sprints.last()
//convert from default dateTime to Date class so we can use the format method later
def endDate = sprint.endDate.toDate()
// Set Due Date
def issueInputParameters = issueService.newIssueInputParameters()
issueInputParameters.setDueDate(endDate.format('dd/MMM/yyyy'))
def updateValidationResult = issueService.validateUpdate(loggedInUser, issue.id, issueInputParameters)
if (!updateValidationResult.isValid()) {
    log.error "Unable to edit the due date to $endDate. Error: $updateValidationResult.errorCollection"
    return
}
def issueResult = issueService.update(loggedInUser, updateValidationResult)