JDBC Access to Jira database - how to associate Sprint with RapidView?

I am a new user of Greenhopper (6.0.6) - my company is using Rapid Boards for managing Agile projects.

I have developed my own reports via direct ODBC database access.

I need to select all issues by sprint of team. One team - one RapidView (table AO_60DB71_RAPIDVIEW).

How to link two tables: AO_60DB71_RAPIDVIEW and AO_60DB71_SPRINT?

Can anyone help?

3 answers

This widget could not be displayed.

Unfortunately, there's no easy way to do this. A board discovers which sprints exist by executing the filter to find the issues then examining the sprint custom field for each found issue.


how can i find filter for ID RapidView? Which table is stored this filter?

This widget could not be displayed.

You can use the REST API of GreenHopper to get the details rather than directly doing it in database. For example, the API "/rapidview/list" will give you details of the boards including the filter details. Checkout the complete REST interfaces of GH at https://jira.atlassian.com/plugins/servlet/restbrowser#/com-pyxis-greenhopper-jira-greenhopper-rest-filter

Anyway this data is also stored "AO_60DB71_RAPIDVIEW" table, column SAVED_FILTER_ID.

This widget could not be displayed.

Hello Renjith,

I'm interested in seeing the REST API for GH, but the link you posted requires login... any way you can make it public? thanks.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

190 views 18 7
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you