Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Jeevan Revuri
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 18, 2020

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.

2 answers

1 accepted

1 vote
Answer accepted
Jeevan Revuri
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 19, 2020

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
Community Champion
November 19, 2020

Great!

Mitesh Chauhan September 15, 2022

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 

0 votes
Brant Schroeder
Community Champion
November 19, 2020

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

Suggest an answer

Log in or Sign up to answer