Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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


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.

2 answers

1 accepted

1 vote
Answer accepted

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)
.header('Content-Type', 'application/json')

//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 ->
//"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 ("$from moved to $value")





Brant Schroeder Community Leader Nov 19, 2020


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


0 votes
Brant Schroeder Community Leader Nov 19, 2020


 Unfortunately that is not available yet in script runner for Jira cloud. More information can be found here:

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events