How to search for issues with key changes?

[Jeanne Howe]

How do you search for an issue who's key has changed?

For example, MAXI-1234 is changed to MINI-4567.

How do you search for 'issue key was MAXI'

[mauricio.groth]

Hi @Jeanne Howe 

As you're on Jira Server, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all issues which are in project MINI and moved from project MAXI. 

 project = MINI AND issue in movedIssues("MAXI")

Check out the documentation for more examples.
I hope this helps!
Maurício

[Carlos Garcia Navarro]

Hi @Jeanne Howe ,

This may be helpful: https://community.atlassian.com/t5/Jira-questions/View-issues-that-have-been-moved-from-one-project-to-another/qaq-p/790346

(it includes a reference to the corresponding feature requests in Server and Cloud respectively: https://jira.atlassian.com/browse/JRASERVER-41039 and https://jira.atlassian.com/browse/JRACLOUD-41039

)

[Florian Bonniec]

@Jeanne Howe 

You cannot do such JQL as WAS operator is only available for Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only. But using Key = MAXI-1234 should return MINI-4567.

[Trudy Claspill]

Hello @Jeanne Howe 

What caused the issue key to change? Was the issue moved to another project, or was the key of the original project changed?

If you are looking for moved issues, there is not a function that will support doing that search natively. You could do a search directly against your database as described here: 

https://confluence.atlassian.com/jirakb/how-to-list-issues-moved-from-one-project-to-another-in-jira-1019410224.html

Or you could look at a third party app such as this one that adds a "movedIssues" function to JQL

https://marketplace.atlassian.com/apps/31399/jql-tricks-plugin?hosting=server&tab=overview

https://www.j-tricks.com/jql-tricks-plugin---dc.html