Does anyone have a query that runs against the Jira database that would count the number of hops a story took (back and forth) between columns in Greenhopper? I'd like to measure average story movement left-to-right and right-to-left.
This got me what I needed:
select ji.pkey as "Story", count(*) as "# of hops"
from changeitem ci join changegroup cg on ci.groupid=cg.id
join jiraissue ji on ji.id=cg.issueid
and ji.project = XXXXX
group by ji.pkey;
...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG