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

Jeevan Revuri 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 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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
TAGS
AUG Leaders

Atlassian Community Events