Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Velocity report sql query?

I know I can view a teams velocity using the Greenhopper velocity report but I create a dashboard in Qlikview that queries the mysql JIRA database and produces more tailored dashboard reports.
I'd like to create a similar report in Qlikview to the greenhopper velocity report but am not sure how to query the database to get this information. Can anyone please provide an example query?

3 answers

Hello Richard,

You may use Qv JIRA Connector (http://1bitsolution.com/qvjiraconnector.html). This connector allows to receive data from GreenHopper add-on. It generates Projects, Sprints, RapidViews and IssueSprints tables.

Then needed report/dashboard can be build in QV.

Best regards,

Roman.

 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Agile

Master the art of thinking big, working small: A conversation with John Cutler

Hello all! It has been 20 years since the agile manifesto was introduced, and closer to 40 years since software development began moving away from a waterfall-type approach. While many teams have ...

1,796 views 10 33
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you