metrics from Jira

Mark Stocker January 23, 2012

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.

3 answers

1 accepted

0 votes
Answer accepted
Neil Arrowsmith
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 23, 2012

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

Mark Stocker January 23, 2012

Thanks neil, going to try this out.

2 votes
Andrew Frayling
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 23, 2012

Hi Mark,

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,

Andrew.

Mark Stocker January 23, 2012

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.

Thanks!

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 23, 2012

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

Suggest an answer

Log in or Sign up to answer