How can I save this data in Custom field? [script runner]

Aitor Bermejo Cacho_g4qd4y

Hello,

I want to save the person who transition a ticket in a custom field but I need to do for our existing tickets...

How can I do with script console? 

 

Thanks all for your help!

Antoine Berry

Hi, 

That would be possible if source and target statuses are sufficient to identify the transition since you cannot retrieve the transition name in history manager. 

Update the JQL request, user_key, sourceStatus and targetStatus (you can use id if needed).

Let me know if you need help updating the custom field.

import com.atlassian.jira.issue.history.ChangeItemBean
import com.atlassian.jira.user.ApplicationUser
import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.IssueManager
import com.atlassian.jira.web.bean.PagerFilter

// Your jql
jqlSearch = "key in (ABC-123, ABC-456)"
SearchService searchService = ComponentAccessor.getComponent(SearchService.class)
def userManager = ComponentAccessor.getUserManager()
IssueManager issueManager = ComponentAccessor.getIssueManager()
ApplicationUser user = userManager.getUserByKey('user_key')
List<Issue> issues = null
SearchService.ParseResult parseResult = searchService.parseQuery(user, jqlSearch)
if (parseResult.isValid()) {
 def searchResult = searchService.search(user, parseResult.getQuery(), PagerFilter.getUnlimitedFilter())
 issues = searchResult.issues.collect {issueManager.getIssueObject(it.id)}
} else {
 log.error("Invalid JQL: " + jqlSearch);
}

def changeHistoryManager = com.atlassian.jira.component.ComponentAccessor.getChangeHistoryManager()
for (Issue issue:issues){
 def ch = changeHistoryManager.getChangeHistories(issue)
 for(int i=ch.size() - 1; i >= 0; i--){
  for (ChangeItemBean bean:ch.get(i).getChangeItemBeans()){
   if (bean.getField() == "status" && bean.getFromString() == "sourceStatus" && bean.getToString() == "targetStatus"){
    log.error("getAuthorDisplayName() : " + ch.get(i).getAuthorDisplayName())
    log.error("getAuthorKey() : " + ch.get(i).getAuthorKey())
   }
  }
 }
}