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

[Smit Belani]

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?

[mauricio.groth]

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,
Maurício

[Sushant Verma]

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.

Regards,
Sushant Verma