I have a simple workflow that looks something like this "In Progress - SYST - UAT" and from SYST and UAT there is a route back to In Progress should either of these phases fail.
Is there a way of capturing how many Jiras are moved back from SYST to In Progress and from UAT to In Progress?
I would like to do this on a monthly basis.
Exactly what I'm trying to write a plugin for at the moment. As Neil says, we can do it with SQL, but it's not fast or flexible enough for my users, they want to click on stuff in Jira and get an answer
We've done this kind of thing in SQL against the Jira database before. As we have Confluence too, we use the SQL plugin to pull similar Jira data on to Confluence pages for reporting.
This page is useful for working out the data mode: http://confluence.atlassian.com/display/JIRA043/Database+Schema
Although Atlassian seem to have removed it from the latest Jira docs, so this is for Jira 4.3
Not sure which version of JIRA you're using, but if you're on 4.4.3 or above you should be able to use the CHANGED operator to search for something similar to:
status CHANGED FROM "SYST" TO "In Progress" DURING("01/01/2012","31/01/2012")
Details on using the CHANGED operator are available at http://confluence.atlassian.com/display/JIRA044/Advanced+Searching#AdvancedSearching-CHANGED
Hope that Helps,
Thanks Andrew, that partly gives me what I want but is does not count how many times a Jira went back and forth. If it ping ponged from In Progress to In SYST 4 times on that query the Jira would only show up once. Going to try the suggestion from Neil below.