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

Question

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?

Nic Brough -Adaptavist- · Answer

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)

David Meltzer · Answer

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?

sclowes · Answer

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