How to use ScriptRunner to update Issue Due Date based on fixVersion release Date

Nathan Walker_9lsto5

Hello,

I have been programming for years but am new to Jira and ScriptRunner.

Sometimes we have to change a versions release date. When I update the fix version release date I want all the issues associated with that version to have updated due dates so that their due date is the new fix version release date.

I found the related article about this topic from 2017 but I don't think it is using script runner and the syntax did not line up with what I am seeing.

Related article: https://community.atlassian.com/t5/Jira-questions/Set-Issue-Due-Date-based-on-fixVersion-release-Date-with-Script/qaq-p/678889

Any help or pointers will be greatly appreciated.

Thanks,

Nathan

 

Here is my  pseudo-code plan.

1. Use Script Listener to trigger when release date is updated.

2. Get version release date.

3. For each issue with a given fix version update issue due date in a similar way to how I did it below.

Is this a good plan?

 

What I'm trying to do.. 

 

Leo_e8op2r

Hi @Nathan Walker,

I would use JQLsearch in listener to fetch all issues affected by the event version/release

The listener should be mapped to "VersionUpdatedEvent"

And the below script will update all issues's Due Date with version's Release Date automatically 

import com.atlassian.jira.event.project.VersionUpdatedEvent
import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.bc.issue.IssueService
import org.apache.log4j.Level
import org.apache.log4j.Logger
import com.atlassian.jira.event.type.EventDispatchOption

def appUser = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()
def searchService = ComponentAccessor.getComponent(SearchService.class)
def issueManager = ComponentAccessor.getIssueManager()
def log = Logger.getLogger("Jira Log")
log.setLevel(Level.DEBUG)

def name = event.getVersion().getName()
def date = event.getVersion().getReleaseDate()
def jqlSearch = "fixVersion = \"${name}\""

SearchService.ParseResult parseResult = searchService.parseQuery(appUser, jqlSearch)
if(parseResult.isValid())
{
    def searchResult = searchService.search(appUser, parseResult.getQuery(), PagerFilter.getUnlimitedFilter())
    def issues = searchResult.issues.collect {issueManager.getIssueObject(it.id)}

    issues.each{ issue ->
        issue.setDueDate(new java.sql.Timestamp(date.getTime()))
        issueManager.updateIssue(appUser, issue, EventDispatchOption.ISSUE_UPDATED, false) 
    }
}else {
   log.error("Invalid JQL: " + jqlSearch)
}

 

you can remove if there is any unwanted packages imported, I didn't check that

 

BR,

Leo