Tracking status changes in JIRA

[Jones Stephen]

Hi,

In a JIRA board with different status, how can i track the changes made between, where the stories went back and forth.

For example: A story was delivered for QA testing and as the QA found an issue, the story was moved back to Development queue. The developer fixes the bug and assigns it back to the QA. The QA finds that the reported bug still does not work, hence moves it back again to the developer's queue.

I am able to see this work log change inside of the JIRA story, but what JQL syntax would help me tracking these changes please?

Thanks,

Jones Peterson

[Dave Theodore [Coyote Creek Consulting] · Accepted solution]

Check out the "WAS *" JQL Operators. They are fairly crude, but they are intended to do what you are after.

[Jones Stephen]

Thank you, @Dave Theodore [Coyote Creek Consulting] !  That was really helpful!

In addition to this, if i need to get a count of how many times the status change occurred, is there a JQL for that or it could be done only with an add-on plugin please?

[Dave Theodore [Coyote Creek Consulting]]

I would actually tackle that problem a different way. This method has the added benefit of public shaming! :D We usually get asked to do this in cases where a client wants to measure the oscillations between Dev and QA or the number of times an Issue was reopened. You will need the JMWE 3rd party App for this and to reference the Jira Workflow documentation.

1. Create a "Number" Custom Field called "Bucks Passed" (or whatever makes sense for your use case) and place it (only) on the View Screen for the Projects in question.
2. Add the "Increase value of field"  Workflow Post Function on the Transition(s) that makes sense in your Workflow.
3. Configure the Post Function to increment the "Bucks Passed" field.

By doing things this way, you will not allow humans to modify the field, since it is only on the View Screen.  The field will not show up unless the buck has been passed at least once. You can use normal JQL to search for issues that meet your criteria and use the results to populate Dashboards, etc. For example:

project = XYZ and "Bucks Passed" < 3

[Jones Stephen]

@Dave Theodore [Coyote Creek Consulting]  Thank you :) Will try this!