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