How to export bug activity report from JIRA for example I want to get transitions of all bug in a

[Deleted user]

Hi Team,

Can you help to to get a report for all transitions we have for bugs in JIRA for a particular project.

[Moga]

Hi Shikha,

We can use the SQL from How to List all the Issue Status Transitions for Past x Days with Issue Key from Database in JIRA.

The SQL should be something like:

SELECT project.pkey, jiraissue.issuenum, changeitem.oldstring, changeitem.newstring, changegroup.author, changegroup.created 
FROM changeitem JOIN changegroup ON changeitem.groupid=changegroup.id 
JOIN jiraissue ON changegroup.issueid=jiraissue.id JOIN project ON jiraissue.project=project.id 
WHERE (project.pkey= 'FPS' and changeitem.field='status');

I hope that this helps. 

Cheers, 
Mogavenasan