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?
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.
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)
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot