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?
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.
Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...
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!
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot