JIRA Isse Transition details from DB

[Vishnukumar Vasudevan]

Hi,

Would like to generate reports based on Issue transitions from Database.

We use JIRA 5.1.3 along with Oracle 11g. Any idea which table we should look for ?

For example, need to know who moved an issue from one status to another one and when.

Thanks, Vishnu

[Teck-En · Accepted solution]

Hey Vishnu, just in case you haven't check on this documentation which has some example queries which you may find it useful: https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindIssuesAffectedbyaGivenTransitioninaSpecificTimeRange

[Onkar Ahire]

You can use ChangeItemBeans to get by field like Assignee, Status, etc.. like this kind of transactions.

e.g.

List<ChangeItemBean> changeItemBeans= changeHistoryManager.getChangeItemsForField(issue, "assignee");

Cheers

Onkar Ahire