How to write JQL to show an issue that transitions into a status more than once

Question

We have a status on our Jira issues called "Rework" that we use for issues that need to be addressed within a sprint.  We do not write Bugs when a story fails if it was entered into the sprint, we simply put it into rework.  If that work espcapes the sprint we write a bug.

I am trying to create a report that shows how many times it takes to complete work.

I can already write a report that shows me all the issues that transition to Rework

project = XSD AND status changed to Rework

This pulls a report that shows all the issues that

What i dont know how to do is to write it to show the issues that went to Rework more than 1 time...

Help :)

somethingblue · Answer

Hi Jeff,

I have not seen a native JQL query that would perform this task since JQL doesn't have the ability to "count" in that manner.  You can use the Database schema documentation and structure a SQL query that gets this information, e.g. structure a query that joins the changeitem table and the jiraissue table to get the changes.  Take a look at the Change History section.

Hopefully that provides some ideas and a path forward!

Cheers,

Branden