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

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?

1 answer

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.

Suggest an answer

Log in or Join to answer
Community showcase
Piotr Plewa
Published Dec 27, 2017 in Bitbucket

Recipe: Deploying AWS Lambda functions with Bitbucket Pipelines

Bitbucket Pipelines helps me manage and automate a number of serverless deployments to AWS Lambda and this is how I do it. I'm building Node.js Lambda functions using node-lambda&nbsp...

657 views 0 4
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot