How to list moved jiras from a project to another in Jira cloud

[Jeevan Revuri]

Hi,

I am trying to list all the jiras to an excel that are moved from one project to another. I found recomendations in jira but not on jira cloud.

I have scriptrunner installed and looking for  sample script to list these jiras.

[Jeevan Revuri · Accepted solution]

I was able to list all moved jiras using the below script on Jira Cloud Script Runner.

// Define a JQL query to search for the issues
def query = '<Query>'

// Fetch the issue object from the key
def searchReq = get("/rest/api/3/search")
.queryString("jql", query)
.queryString("fields","summary")
.queryString("expand","changelog")
.header('Content-Type', 'application/json')
.asObject(Map)


//save the search results
Map searchResult = searchReq.body

searchResult.issues.each { Map issue ->

issue.changelog.histories?.items?.eachWithIndex { it, i ->
def map = it

map.each { entry ->
//logger.info("Entry ${entry.field}")
def level1 = entry
def answer = ''
def from = ''
level1.eachWithIndex { key, value, j ->

if(value == "Key"){
answer = 'Key'

}

if(key == "fromString" && answer == "Key") {
from = "$value"

}
if(value == "${issue.key}" && answer == "Key") {
// This will display the old ticket number and new ticket number
logger.info ("$from moved to $value")
}

}

}

}

}

[Brant Schroeder]

Great!

[Mitesh Chauhan]

Hi Jeevan,

My requirements are exactly same as your :-) - Have you managed to get the results in Excel since 2020?

I am trialing ScriptRunner and quiet novice to its syntax. I have managed to execute your script and getting the Issue Id from Old project to New - which is almost perfect!

I'd like to add more fields to output so that I can manipulate the data in excel. 

• Issue Created date(before it was moved)
• Issue Moved Date
• Resolution Date

Any help would be greatly appreciated.

Many thanks

Mitesh 

[Brant Schroeder]

Jeevan,

 Unfortunately that is not available yet in script runner for Jira cloud. More information can be found here: https://community.atlassian.com/t5/Jira-Software-questions/Jira-Cloud-Scriptrunner-Find-Issues-that-were-moved-from-other/qaq-p/1267012