Finding issues that have been moved from one project to another project

[Jules McCool]

Hi there

Is there a JQL query I could use to get a list of all issues that have been moved from 1 project to another?   

The reason we need this is I am trying to get a list of issues that have been moved from 1 project to another for tracking and reporting purposes.  I would also like to generate a report to show where the issues move too, priority and status of issue. 

Generally the issue will only move to 1 project but there have been some cases where it has moved multiple times.  We have a combination on team-managed and company-managed projects where the issues could move too.  

Thanks

[Arkadiusz Wroblewski]

Hello and welcome to the Community @Jules McCool 

Native no.

options are usually one of this 3: 
1. Forward-looking tracking with Automation
2. Historical extraction through the REST API/changelog
3. Marketplace app that indexes issue history

For future moves, you should create an automation rule with the Issue moved trigger and store values such as:
Old issue key Old project New project Moved date Moved by

[Rahul_RVS]

Hi  @Jules McCool 

Welcome to the community !!

You can use Jira Rest Api's to pull this information and build your own custom solution.

However if you need detailed reporting to track changes for multiple issues, you may want to have a look at a mktplace app for the same.

We have built an app to extract changelog data in a simple and easy to use interface. The data can be exported to a CSV file as well.

It provides complete details of who changed the data, what was changed and when. 

Issue History Reports

Do give it a try.

Disclaimer : I am part of the app dev team