Looking to report in JIRA what tickets have been committed to git since last release

[Chuck Miller]

I am looking to find a way to make a dashboard to show the code that has been committed since the last release.  We release code to our SaaS environment monthly, as tickets are worked, the code is committed to git.

I tried this filter:

project in (<project list>) and status in (Done) and development[commits].all > 0 and updated > '2022/07/20' order by created DESC

But this is going off the ticket being updated (which could have happened for a different reason).  So I am thinking i need a way to filter on when the commit was performed (??)

Any ideas would be awesome - thanks!

[Aron Gombas _Midori_ · Accepted solution]

I don't think it can be done with the default setup.

Here is an idea which could maybe work:

1. Add a new datetime type custom field to your issues, intuitively called "Last commit"
2. Then, have an automation rule, which updates this field when there is a commit against that issue

Now, you have an automatically updated field which you can flexibly query in JQL!

[Chuck Miller]

Thank you much!  That makes sense!