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)
...It's true that there are projects in Jira; but they are merely a way to cut off issues, to tell them apart from other sections of work and to apply rules that are specific to that team (the schemes)....
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