Automating JIRA Reports - Ideally to Confluence

[Andrew Sedlacek]

Hey all! I'm trying to help automate our weekly Sprint Review and our Product Updates. I'm trying to figure out a way to automate a few things:

1. Summarize all tasks completed in the weekly Sprint.

2. Sprint completion report - highlight which products were affected (i.e. new functionality, bug fixes, etc) for our engineering team.

3. Translate this into a Confluence document each week, which I can then use to send updates to our entire company.

[Nikola Perisic]

Welcome @Andrew Sedlacek 

1. When you say summarise, does this mean summarising the content of the issues completed within the sprint or to have the list of the issues completed during weekly sprint? For summarising the content of all of the issues could be actually done if you have one Epic that contains the user stories and then use the Atlassian Intelligence to summarise everything, otherwise it is not feasible. If you want to have the list of the issues, you can use the JQL: 

project = PLAT AND sprint in openSprints() AND statusCategory = Done

      2. For sprint completion report, use the Sprint Report which contains work completed or pushed back in the backlog in each sprint. Jira doesn't have the ability to create automation that as an action will create the report, so this would have to be done manually.

     3. Due to limitations in Jira, for sprint reports, you can share the report with other users within your company. This would also have to be done manually. For this you can also check this page: https://www.reddit.com/r/jira/comments/18lkni3/jira_automation_rules_for_confluence_page_with/

[Andrew Sedlacek]

Ok awesome, this is super helpful!

Is it possible to modify the Sprint Reports? It doesn't appear to show the Epics, which would be great.

I'm actually looking to summarize both 1. issues completed and 2. content of those issues. I want to communicate to the team "This is how Epic X changed this week, here are the new features, here are the bug fixes".

Again, ideally, then have a Sprint Report document automatically created in Confluence to summarize everything into a product-by-product update, showing new features, bug fixes, etc.

Toying with the idea of creating an Agent to basically review the Confluence Sprint Report and create a nice bullet point document with some intro/analysis in human language.

[Nikola Perisic]

By default you cannot modify the reports in Jira, you would need a third party app for this like eazyBI. To summarize the content of the issues and issues completed could be done with the usage of Atlassian Rovo. 

[Andrew Sedlacek]

Ok great, thank you Nikola!