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!
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.
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
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG