nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confluence Variables in JIRA JQL macro

lukasz_switaj

Hello,

I create release notes pages from template (env - cloud).

Those contain a few (between 3 and 7) JIRA macros. I'd like to fill it automatically once I provide the version number (ideally under the variable $version). Is it possible somehow? Do you have such function (using confluence variables in JIRA macros) on your roadmap? Doing it from some Wizzaird level would be also fine.

Also, it would be great to include such info (version) in the page name.

On the attached screenshot you can see: what's the current state -> what's the goal: Screenshot 2020-05-18 at 00.44.26.png

Accepted answers

Ignacio Pulgar

Hi @lukasz_switaj ,

There's no way of doing so natively.

On Server instances, there's a workaround by using the Confluence Source Editor free app, as it allows to search & replace the fixVersion value.

On Cloud instances, I've just seen this Source Editor for Confluence app, which seems to be quite similar to its Server counterparty, but I've not tried it yet.

Hope it helps.

All comments

Ignacio Pulgar

Hi @lukasz_switaj ,

There's no way of doing so natively.

On Server instances, there's a workaround by using the Confluence Source Editor free app, as it allows to search & replace the fixVersion value.

On Cloud instances, I've just seen this Source Editor for Confluence app, which seems to be quite similar to its Server counterparty, but I've not tried it yet.

Hope it helps.

lukasz_switaj

Thanks for the response, Ignacio.
Do you think that in such a case the free option doesn't exist? (cloud)
Maybe there is an alternative way of doing that. Writing own macro, or sth like that? Do you have some ideas?

Ignacio Pulgar

You are welcome, @lukasz_switaj

I'm afraid there's no free version of that addon for Confluence Cloud, and I do not know of any other alternatives.

I think this kind of goal would require to develop your own Confluence Cloud app for getting something like that, although I'm not 100% sure of that.

Which I would recommend to do is a workaround based on doing things differently:

Save a filter named ie: version report with this JQL: fixVersion = 1.3.0
Create and save the filters you set in the macros with the same JQL, except that you should substitute fixVersion = 1.3.0 with filter = "version report"
Create a dashboard in Jira with gadgets instead of macros, and feed them with the filters you saved in the previous step

After having followed these steps, you will have something similar to your macros, and you will be able to update all filters at once by changing the fixVersion of your version report filter.

(This way of referencing a saved Jira filter is also available within Confluence macros)

Once you have the dashboard displaying all the relevant data related to a given version, select all gadgets content with your mouse and Copy (Ctrl + C).

Go to a Confluence page where you would like to store your version report, enter its edit mode, and Paste (Ctrl + V).

By creating the page this way, you will get a static snapshot of the data, as opposed to dynamic data which would vary over time if the issues in the report changed.

That's usually good, because as time passes, you will retain the picture taken at a certain point in time, which is usually the best approach for this kind of reports.

Hope it helps.

Ignacio Pulgar

Of course, once you have to build a new report for the next version, you just have to change and save just your version report filter, and just copy and paste the new data into a new Confluence page.

You may need to apply some manual adjustments to the pasted content, but it will save you tons of time when creating this kind of version reports.

Best regards.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

jira

cloud

template

jql

variable