nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

metrics from Jira

Mark Stocker2

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.

Accepted answers

Neil Arrowsmith

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

All comments

Neil Arrowsmith

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

Andrew Frayling

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.

Nic Brough -Adaptavist-

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

Mark Stocker2

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!

Mark Stocker2

Thanks neil, going to try this out.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira