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

Question

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?

Renjith Pillai · Answer

You can register https://jira.atlassian.com/secure/Signup!default.jspa and login with that account.

Peter Dittman · Answer

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.

Renjith Pillai · Answer

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.