nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Updating a field for all issues matching a condition

David Harkins

What is the best / fastest way to update a field for all issues matching a condition?

After a bulk data import, we have some temporary fields

i.e. 'Assignee (T)'

I want to update 'Assignee' to myself, where the 'Assignee (T)' field contains my name.

This can be done as a bulk operation, but limited to 1000 Max and there are over 35K. Not all mine, but will need to re-run for various users and with 5 other (T) fields.

I was thinking scriptrunner, is this possible?

Does anyone have a good starting point?

Accepted answers

David Harkins

After some more digging, Trial and error in TEST I have a working Solution:

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

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

def currentUser = userManager.getUserByName("David.Harkins")

def jqlSearch = "KEY = ALOGS-113154"
def NewAssignee = userManager.getUserByName("David.Harkins")

SearchService.ParseResult parseResult = searchService.parseQuery(appUser, jqlSearch)
if (parseResult.isValid()) {
 def searchResult = searchService.search(appUser, parseResult.getQuery(), PagerFilter.getUnlimitedFilter())
 def issues = searchResult.results.collect {issueManager.getIssueObject(it.id)}
 issues.each { issue ->
  log.info("Issue key: "+ issue.getKey())
  issue.setAssignee(NewAssignee)
  ComponentAccessor.getIssueManager().updateIssue(currentUser, issue, EventDispatchOption.ISSUE_UPDATED, false)
  log.info("Updated Issue key: "+ issue.getKey())
 }
} else {
 log.error("Invalid JQL :" + jqlSearch)
}

All comments

Suhas P

Hi, Yes, you can do that by running groovy script from script console. You need to first search the issue using JQL and then apply your updates on each issue (set assignee in your case). Check out following code.

import com.atlassian.jira.component.ComponentAccessor

import com.atlassian.jira.issue.Issue;

import com.atlassian.jira.issue.CustomFieldManager

import com.atlassian.jira.issue.fields.CustomField

import com.atlassian.jira.issue.IssueManager

import com.atlassian.jira.issue.MutableIssue

import com.atlassian.jira.event.type.EventDispatchOption

import com.atlassian.jira.issue.comments.CommentManager

import com.atlassian.jira.issue.ModifiedValue

import com.atlassian.jira.issue.util.DefaultIssueChangeHolder

import com.atlassian.jira.bc.issue.search.SearchService

import com.atlassian.jira.bc.issue.search.SearchService.ParseResult

import com.atlassian.jira.web.bean.PagerFilter



import org.apache.log4j.Level

import org.apache.log4j.Logger



Logger log = log

log.setLevel(Level.INFO)

def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()

SearchService searchService = ComponentAccessor.getComponent(SearchService.class)



def issueManager = ComponentAccessor.getIssueManager()


def cfm = ComponentAccessor.getCustomFieldManager()

def commentManager = ComponentAccessor.getCommentManager()

def cf = cfm.getCustomFieldObject("customfield_11508") //your CF


log.info("CF Object : "+cf)


def jqlQuery = “YOUR JQL”


SearchService.ParseResult parseResult =  searchService.parseQuery(user, jqlQuery)


log.info("Parse results: "+parseResult)

List <Issue> issues = null

if (parseResult.isValid()) {

    def searchResult = searchService.search(user, parseResult.getQuery(), PagerFilter.getUnlimitedFilter())

    issues = searchResult.getIssues()

    log.info("Search results: "+issues)

} else {

    log.error("Invalid JQL: " + jqlQuery);

}


issues.each{

    log.info("Issue key: "+it.getKey())

    def cfv = cf.getValue(it)

   log.info("CF Val : "+cfv)

    

/***PUT your update CF code here..***/




    issueManager.updateIssue(user, issueManager.getIssueObject(it.getKey()), EventDispatchOption.DO_NOT_DISPATCH, false)




}

David Harkins

@Suhas P Thanks :-)

I'm guessing the update code would be as simple as:

issueToUpdate.setCustomFieldValue(cf, "myvalue");

Suhas P

If its just an assignee the following should work

def userManager = ComponentAccessor.getUserManager();
def user = userManager.getUserByName(userId)

issue.setAssignee(user);

Suhas P

Make sure you try it in non-prod instance first, on small number of issues. confirm the script is working and then use actual JQL in first non-prod and then finally in production.

David Harkins

After some more digging, Trial and error in TEST I have a working Solution:

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

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

def currentUser = userManager.getUserByName("David.Harkins")

def jqlSearch = "KEY = ALOGS-113154"
def NewAssignee = userManager.getUserByName("David.Harkins")

SearchService.ParseResult parseResult = searchService.parseQuery(appUser, jqlSearch)
if (parseResult.isValid()) {
 def searchResult = searchService.search(appUser, parseResult.getQuery(), PagerFilter.getUnlimitedFilter())
 def issues = searchResult.results.collect {issueManager.getIssueObject(it.id)}
 issues.each { issue ->
  log.info("Issue key: "+ issue.getKey())
  issue.setAssignee(NewAssignee)
  ComponentAccessor.getIssueManager().updateIssue(currentUser, issue, EventDispatchOption.ISSUE_UPDATED, false)
  log.info("Updated Issue key: "+ issue.getKey())
 }
} else {
 log.error("Invalid JQL :" + jqlSearch)
}

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-service-management

jira-service-management-server