How can i use ScriptRunner for JIRA Cloud to find all issues i moved from Project A to Project B?

Josh Kronick

We moved about 300 issues from Project A & C to Project B and forgot to attach components based on which projects they came from, so we need to find the issues that were moved in order to re-attach components.

 

i know previously, scriptrunner for JIRA Cloud didnt even exist, but now that it does, is it possible to use it to find the issues that were moved from Project A to Project B? or to find the previous issueKey ? rather than having to go through the history of each issue that was moved to find out which project it was moved from?

 

please help

 

Thanks,

 

Josh

Bastian Stehmann

Hi,

this is a snippet from server, but maybe something like this will work on cloud too.

def String jqlQuery = 'project=B'
 def fromProject1 = 'A'
def fromProject2 = 'C'

 def result = ''

 def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
 def searchService = ComponentAccessor.getComponent(SearchService.class);
 def user = ComponentAccessor.jiraAuthenticationContext.getLoggedInUser()

 List<Issue> issues = null

 def parseResult = searchService.parseQuery(user, jqlQuery);

 if (parseResult.isValid()) {
 def searchResult = searchService.searchOverrideSecurity(user, parseResult.getQuery(), PagerFilter.getUnlimitedFilter())
 issues = searchResult.issues
 } 

 issues.each{ Issue issue ->
 def oldKeys = changeHistoryManager.getPreviousIssueKeys(issue.id)
 oldKeys.findAll{it==~/$fromProject1.*/}.each{
 result += "$it -> ${issue.key}, "
 }
 issues.each{ Issue issue ->
 def oldKeys = changeHistoryManager.getPreviousIssueKeys(issue.id)
 oldKeys.findAll(it==~/fromProject2.*/}.each{
 result += "$it -> $(issue.key),"
 )