automatically enerate JIRA issue change report based on svn checkins associated with the JIRA item

[Laurie Reynolds]

We would like to automatically generate and email a report that includes JIRA items that have changed in the last week due to associated svn checkins. Additionally, we'd like to include information about the changes (e.g. who made the change, the associated comment and what files were changed.) I have found two reports, which by themselves aren't what we are looking for and I'm not sure how to configure JIRA to generate and email the report weekly. Also the JIRA items will be in various states: Open, Resolved, and a couple of custom status states that we have created.

1) Limitations with the available svn commit report

• It doesn't include the description of the JIRA item
• It doesn't include the status of the JIRA item
• There does not seem to be a way to filter the svn commits to only show the last n days.

2) Limitations of the JIRA item filtered on the update date

• If the svn item only changed because of an SVN commit, it won't be included in the report. SVN commits does not update the update date for the JIRA tiem
• The JIRA report does not include who made the change
• The JIRA report does not include what files were changed.

My questions are:

1) Is there a way to generate such a report? If not, any hints on available apis to programmatically generate it?

2) How do we configure JIRA to automatically send it on a weekly basis?

[Norman Abramovitz]

You can filter svn by specifying dates for revisions. Yes, you need to calculate the date using whatever scripting language you use and most scripting languages have date functions to do calculations and formatting.

svn log --revision {2012-11-01}:{2002-11-29} ...

svn log --revision {2012-11-01}:HEAD ...

svn log --revison {2012-11-01 23:59} ...

If you are using fisheye or subversion plugins you will have Jira keys listed in your svn log entry.

You can then use the REST apis to retrieve the issue data.

So have fun with favorite scripting language that supports making https calls.

Do not forget to enable the REST API.