How do I count the number of reopen events, order by number of reopen events?

[Kamilla]

I need a ticket  list (filtered for the issues in current sprint )about the number of times that a ticket has been transitioned to Reopen status.

Does this make sense? 

Thanks for help

[Bill Sheboy]

Hi @Kamilla 

To confirm, you want a query for issues that were "done" and have been moved back into "in progress", correct?

If so, this query will work, as long as you only have classic projects in your instance:

project = myproject AND sprint in opensprints() AND status != Done AND status CHANGED FROM Done AFTER startOfYear() ORDER BY Key

However, if you are using Next Gen, or have any Next Gen projects in the instance, this may not work.  There are a couple of open defects where Next Gen is causing side-effects for the status change query functions.

Best regards,

Bill