Please can I get the SQL query or JQL which is fired when one clicks the transitions tab in the activity section?
Refer the image below. The objective is to get a report with this information for all issues in a particular sprint or time period.
This is for JIRA 6.2.x and above
Activity - Transitions Tab.jpg
It doesn't run any queries directly. The issue contains a history which is a set of changes to the issue with date/time stamps. When you look at the issue, JIRA pulls up all the data. This tab simply reformats the history selectively.
The data for those changes is in the tables changegroup (holds issue id, and the change date and time) and changeitem (tells you what changed as part of a changegroup record, so it's a list of fields and their "from" and "to" values - you'll want to select this by looking for changes of "status")
A similar report can be created by using SQL for JIRA as it supports the issue changes history. Simply transform your JQL into a SQL query and join it with the ISSUECHANGES table which provides the old and new values for the field='Status' column filter as well as the user who performed the change and the timestamp.
And even if you use the SQL for JIRA Reports and Charts free extension you would be able to reproduce just the same GUI that you have attached as picture.
Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs