Search for issues that is now moved into a different project.

[Erwin Manuel]

Hi,

I need to search for issues via their previous project.

e.g. AAA-1 is moved to new project as BBB-10.

I need to search for issues that is originally from AAA but is now moved in project BBB, I came accross: https://marketplace.atlassian.com/plugins/com.palm.jira.plugin.search.boolean/version/13 - Change History Searching, But could not install the plugin properly, reindex is failing.

Is it possible to search using DB? I only need the issue keys.

Thanks in Advance!

[Zul NS [Atlassian] · Accepted solution]

You can call the issuekey using REST API and it will return results of the new issuekey if the issue has been moved. You might want to refer http://docs.atlassian.com/jira/REST/latest/#id90715

This feature using REST API is however, only available iin JIRA 5.0 and later as stated in https://jira.atlassian.com/browse/JRA-26806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

The JQL feature for this is not yet available but has an improvement request in https://jira.atlassian.com/browse/JRA-30074?page=com.atlassian.streams.streams-jira-plugin:activity-stream-issue-tab

Hope this helps.

[Erwin Manuel]

We are using 4.4.4 no good for us :(

[Erwin Manuel]

I was able to create a DB script that does this using the base script in: https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-Findoldissueidsforissuesthathavebeenmoved