How can I query the history of an issue?

[Robert Matthews]

We need to run a query to capture the transition state change (in the middle of a workflow) from the History within individual issues. We are running Jira 4.3.4.

[rishiranka_bitbucket · Accepted solution]

List Li = ComponentManager.getInstance().getChangeHistoryManager().getAllChangeItems(issue);

Where issue is the issue object which you can retrieve it from issue Key

[Robert Matthews]

I do not have access to the database. These queries need to be run within the Jira application and by a number of different people. The needed query must run against multiple projects as well.

[Jobin Kuruvilla [Adaptavist]]

From JIRA 4.4, there is WAS and CHANGED operators you can use. Nothing in 4.3.4 AFAIK.