JQL to find out OLD Project of a Specific JIRA Key.

Smit Belani April 10, 2023

I've a below given use case.

QA has by mistake moved the ticket from Project A where it's key for A-200 to Project B where the key got changed to B-300.

Now, there are 250+ test cases which got affected due to this. 

so, how can i write a JQL to find out this transitions issuekeys?

I can see the history as below:

and i tried "project was in (QABP) AND project = VDB" JQL but i'm getting the following error. can anyone help me on this?image.png


2 answers

0 votes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 10, 2023

Hi @Smit Belani

I’m Maurício, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all issues that have been moved to another project.

project = VDB AND issue in movedIssues(“QABP”)

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,

0 votes
Sushant Verma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 10, 2023

Hi @Smit Belani 

Welcome to the community!

You can't do this out of the box since the WAS and CHANGED operators can be used with the Assignee, Fix Version, Priority, Reporter, Resolution and Status fields only.

If you're on Server, you can do this with JQL Tricks . You can follow this documentation

Or You can use Script Runner plugin and use the script to find all issues moved from one project to another.

Sushant Verma

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events