Status changes


I'm looking for a way to find all issues whose status changes from one to the other eg from DEVELOPMENT to TEST. Does anyone know any interesting solution to this problem?



2 answers

0 vote
Thomas Schlegel Community Champion Oct 16, 2017

Hi Stefan,

use this JQL:

status changed from development to test

I think, you have to refine this query to get a better result, but this is the base query you have asked for.

Hi Thomas,

Thanks for your answer, I have one more problem I wanted to find a issue with repeating sequences eg. issue where status changed from DEVELOPMENT to TEST couple of times. Is it possible to build such a jql query?



Hi Stefan,

maybe something like that:

status changed from development to test and status changed from test to develeopment and status = test

Hi Stefan,

We have plugin Status History PRO which could help to resolve your problem. In the last version, we've added three reports that allow you to view statuses, find status changes, and summarize status changes on project. We also have a free version of this plugin - but it does not have the reports I mentioned earlier. More information you can find in documentation

If you have any questions please let us know.



I have read the documentation and it seems that the reports contain what we expect. Especially the status change report. I have a question related to the Repeated parameter. Will this parameter allow us to search for a issue with recurring status changes? We would like to know which issue often returns from TEST to DEVELOPMENT.



Yes, This parameter specifies the number of occurrences of the selected status sequence (eg. Status from: DEVELOPMENT and Status to: TEST). It accurately defines a relation equal or more than. For example, if you want to find all issues that have changed more than (or equal) twice the status from DEVELOPMENT to TEST you need to enter in the Repeated value 2. 

OK, this week I'm busy but next week I'll test your plugin and let you know if it's OK.

I have two more questions about the summary report.

My first question is about All data - can you explain how it works?

The second one deals with Worklog - the summary report includes the users table and the total number of logged hours for each one - is it possible to add this information to status such as IN PROGRESS and the total number of logged hours by users in that status?



Hi Stefan,

The All date option aggregates data for all status changes to issues. The report aggregates all status changes that were ever made on all issues in the project. By default, this option is disabled and the data that is summarized is only for the current state - for example, the number of issues that are currently in the IN PROGRESS status is displayed.

Yes, In a future release, we want to add a worklog summary for each status. In addition, we also want to add JQL functions that will allow you to create status change queries. A new version should appear at the end of November or early December.


Thanks for the answer. This week we start testing your plugin.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jun 14, 2018 in Jira Service Desk

How the Telegram Integration for Jira helps Sergey's team take their support efficiency to the bank

...+ reading Fantasy). The same is true for him at the bank he works for: Efficiency is key when time literally equals money. Read on to learn how Sergey makes most of the time he has by...

540 views 3 5
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you