How to create custom page in Confluence

[Nikita Spitsky]

Hi community, I try to create Jira Automation for sprint reporting. I'd like to get next flow: when I complete a sprint Jira Automation create page in Confluence with issues list on Page from this sprint. 

I tried to use Lookup Issue but I stuck when I create JQL quure, because I can't get how to use variables there.

And also, I don't understand how I can parametrisation my Confidence template. Maybe is there some manual for it?

[Kristian Walker _Adaptavist_]

Hi Nikita,

I can confirm that if you use ScriptRunner for Jira Cloud it would be possible to achieve this requirement.

You could achieve this by configuring a Script Listener to run on the Sprint Started event for your project.

The script would start of using JQL to search for all issues in the sprint, and we have an example here that shows how to search for issues using JQL inside a script that you can use as an example.

For the JQL you can refer to the Atlassian page here to see the JQL query to use to return the issues in the sprint that you require.

Your script would then create a new confluence page with the issues returned on it, and I can confirm we have an example of how to create a confluence page here.

You will be able to use these examples as a reference guide to help create the script that you require.

Regards,

Kristian