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

Question

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 · Accepted Answer

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 · Accepted Answer

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

Birkan Yildiz _OBSS_ · Accepted Answer

Hey @Jules McCool

First, welcome to the Community!

If you are open to using a 3rd party app, Historian - History Explorer for Jira can help you build this exact report.

Here is how its features solve your specific requirements:

Selecting Work Items via JQL: You can enter your JQL query in the search box to limit the report to only the issues that have moved.

Selecting Fields: To get the exact columns you need for your report, you can specifically select the "Project", "Status", and "Priority" fields. This filters out irrelevant changelogs and focuses your report on what matters.

Work Item-Based View: Instead of clicking into each issue manually, Historian organizes the report so each work item appears as a row. You can expand it to see every individual project move chronologically, ensuring you capture the full history of issues that have moved multiple times.

Export Data: Once your report is generated, you can instantly export it to Excel (XLSX) or CSV for your tracking and reporting purposes.

You can check it out on the Atlassian Marketplace. Hope this helps!

Disclosure: I am part of the OBSS team, the developer of the add-on.

Best,
Birkan

Natalia_Kovalchuk_SaaSJet_ · Accepted Answer

Hi @Jules McCool !

Unfortunately, Jira doesn't provide JQL that returns all issues moved from one project to another. You can check the history of each issue manually, but it's a time-consuming process, especially when you need to check a great number of issues.

I can recommend you try Issue History for Jira (Work Item History) by SaaSJet. It can help you to do the following:

* filter changes by project, user, date

see when an issue was moved from one project to another

check the previous and new project/key values

track priority, status, or any other field changes in the same report

export the results to Excel or CSV

So, in your case, you could filter the history by the specific project and get a report showing where issues were moved, exactly when it happened, and which other field values were changed.

Hope it will be useful!

Jules McCool · Accepted Answer

Hi @Rahul_RVS, @Natalia_Kovalchuk_SaaSJet_ and @Birkan Yildiz _OBSS_

Thanks for your replies but we are looking for an option where we don't have to use a paid 3rd party if possible