Please can I get the SQL query or JQL which is fired when one clicks the transitions tab in the activity section?

Santak Das July 21, 2015

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

2 answers

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 21, 2015

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")

Santak Das July 22, 2015

Thanks Nic

1 vote
Pablo Beltran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 30, 2015

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.

Suggest an answer

Log in or Sign up to answer