ODBC Access to Jira database - how to associate issues with a Rapidboard sprint?

I am a new user of Greenhopper (5.10) - my company is using Rapid Boards for managing Agile projects. Since the rapid boards are relatively new and most of the existing reports do not work properly, I have developed my own reports via direct ODBC database access. I need to create a series of reports based on issues for a given Rapidboard sprint and am unable to identify where this is stored or how to create a join with the Jiraissue table.

Can anyone help?

1 answer

Hi David,

Could I ask what you mean when you say the new reports don't work properly? There's no way we can improve if we're not aware of problems.

The Sprint information is stored in the ao_60db71_sprint table. The id from this table is stored in to the Sprint custom field on issues that are in the Sprint.

Thanks,
Shaun

Shaun - none of the existing reports for Agile use the concept of the sprint as defined by the rapid board (including widgets for the dashboard) - they all still use the version as the sprint identifier.

Understood David, I thought you were suggesting that none of the existing reports (i.e the Sprint, Burndown and soon to be released Velocity reports) were any good.

Thanks,
Shaun

OK - I've found how to create a data set of all tasks and subtasks for a given rapidboard sprint. I now have one addtional data releated question - I see that I can get time worked by day via the worklog table - I assumed I could extract daily changes to the remaining estimate from the changeitem table (I see on the newest burndown chart that this data is captured and stored) - but I am not able to establish the relationship between worklog and changeitem.....is there an intermediate table somewhere I am not seeing?

changegroup - changeitems each represent one change on the issue, and changegroup represents a batch of changeitems that the user made in one transaction. (e.g. editing summary, description while going through open -> in progress - three individual changes done in one go)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 05, 2018 in Jira Software

Jack Graves: Real Ale enthusiast with a knack for Jira Software implementation

@Jack Graves [AC] first caught our eye with his incredible breakdown of what, in his opinion, can make or break a Jira software implementation. (Read his thoughts on this thread)! In this follow...

96,836 views 4 14
Read article

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