Steps to pass Jira sprint number to Jira Issues/Filter Macro

[Martin Wasiak]

We have a heavily customized Sprint Review page.  Unfortunately, each week, we have to manually edit the sprint name in 10+ JQLs for different Jira Issues/Filter Macros.

I've seen people write Confluence Macros to do that, but can't figure out how to start.

For us, either defining the sprint value in the URL or once in the page would be ideal.

[KAGITHALA BABU ANVESH]

Hi @Martin Wasiak ,

project = ABC Sprint in openSprints()

The above JQL only provides current active sprint issues. by using this there is no need to edit sprint names after sprint completion.

This will reduce manual updating of sprint names in JQL after sprint starting.

[Martin Wasiak]

This won't work once the sprint is completed, hence I'd like to pass the value in the URL.

Ideally, I'd like to reuse the page in one of two ways:

* I'd like to be able to clone the page and edit the sprint number in one place.

* Pass the sprint number in the URL.  For example: https://confluence.company.com/display/VP/page?sprint=2545

Then my JQL would look like:

issuetype=story where resolution is not empty and sprint=2545