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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

Recommended Learning For You

Level up your skills with Atlassian learning

Learning Path

Apply agile practices

Transform how you manage your work with agile practices, including kanban and scrum frameworks.

Learning Path

Configure agile boards for Jira projects

Learn how to create and configure agile Jira boards so you can plan, prioritize, and estimate upcoming work.

1.8h Intermediate

Jira Essentials with Agile Mindset

Suitable for beginners, this live instructor-led full-day course will set up your whole team to understand how to use Jira with an agile methodology.

Was this helpful?

Thanks!

TAGS