How do I get completed user stories from JIRA to show in confluence?

[Megi Alexander]

I have created a sprint report in Confluence and need to populate it with the completed user stories from JIRA. Is there any way of setting this up so it is automatic and just updates the report in Confluence once the user story has been completed in JIRA? 

[Sireesha Dugginapeddi [Appfire]]

Hi @Megi Alexander,

Yes, there is a way to insert and automatically update completed Jira issues on a Confluence page. You can use the 'Jira Issues' macro. This enables you to use Jira Query Language (JQL) to fetch required issues from Jira. JQL helps you filter the issues based on the defined query, which in your case should be something like -

Project = XYZ AND fixVersion = x.xx AND Resolution = Closed (or Complete or whatever status is defined in your Jira).

Also, you can define the sorting order of the issues list using JQL.

To understand more about this macro, please refer to https://confluence.atlassian.com/doc/jira-issues-macro-139380.html. This article also navigates you to JQL help, where you can learn more about the query.

Hope you found what you are looking for!

Thanks

Sireesha