Get product advice from experts

Ask a question →

Join a community group

Find a group →

Advance your career with learning paths

Take a free class →

Earn badges and rewards

Connect and share ideas at events

See the calendar →

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

Suggest an answer

Log in or Sign up to answer

0 votes

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

0 votes

See this other thread: https://answers.atlassian.com/questions/314800

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

0 votes

http://stackoverflow.com/questions/6814683/in-jira-greenhopper-how-do-you-directly-access-the-greenhopper-stored-data-to

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

Recommended Learning For You

Level up your skills with Atlassian learning

Jira Align Program Essentials

Learn how to use Jira Align at the program level and how to plan for and manage your Program Increment (PI).

Managing Agile Boards and Reports

Learn how to pick the right board type for your team and customize it to fit your specific requirements.

Atlassian Certified Associate

Jira Software Board Configuration

Earn an associate-level credential from Atlassian that shows you can effectively configure Jira Software boards.

1h Intermediate

Was this helpful?

Thanks!

TAGS