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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.