Completing a Sprint doesn't count as an issue update

Paul Madison

We are having an issue with our reporting where jira issues have a last updated date before the date a sprint was completed.

 

Is there a way to update all of our Jira issues in sprints after the sprints are completed?

Paul Madison

I ended up using a Script Listener (Using Scriptrunner) with the following code.  The code will edit a field on the issue, so that the ticket is updated.

 

---

////  Sprint Closed Event

////  All Projects

// get board and sprint info

def getBoardResponse = get("/rest/agile/1.0/board/${sprint.originBoardId}").asObject(Map)

assert getBoardResponse.status == 200

def board = getBoardResponse.body

// log sprint info

logger.info("Sprint '{}' with id: {} has been closed. Its origin board is: '{}' with type: {}", sprint.name, sprint.id, board.name, board.type)

// get sprint issues

def sprintIssues = get("/rest/agile/1.0/sprint/${sprint.id}/issue").asObject(Map)

//set variables for looping

int maxResults = sprintIssues.body['maxResults']

int totalIssues = sprintIssues.body['total']

int startAt = 0

def issueKey = "key"

def newvalue = 'trigger update from Script Listener'

final customField = 'customfield_12345'  // add custom field id here

// loop through issues and update them

for (startAt = 0; startAt < totalIssues;)  // loop through pagination

{

    // if on the last call, adjust the maxResults variable to only loop the correct number of times

    if (totalIssues - startAt < maxResults)

    {

        maxResults = totalIssues - startAt

    }

   

    // loop through each issue

    for (int i = 0 ; i < maxResults; i++)

    {

        //get issue key

        issueKey = sprintIssues.body['issues'][i]['key']

       

        //update issues, update Reporter Company field

        put("/rest/api/2/issue/${issueKey}")

            .header('Content-Type', 'application/json')

            .body([

            fields: [

                    (customField): newvalue

                ]

            ]).asString()

    }

   

    // get next set of data (pagination)

    startAt = startAt + maxResults

    sprintIssues = get("/rest/agile/1.0/sprint/${sprint.id}/issue?startAt=" + startAt).asObject(Map)

    if(sprintIssues.status != 200)

    {

        break

    }

}