Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Confluence Variables in JIRA JQL macro


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



1 answer

1 accepted

0 votes
Answer accepted

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.

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?

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:

  1. Save a filter named ie: version report with this JQL: fixVersion = 1.3.0
  2. 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"
  3. 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.

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.

Hi guys,


Thanks for this hint! I currently have a similar "issue" I have a confluence page with multiple JIRA SQL Macros in there. I want to take some value from the confluence page as a variable for the fix version for all these JIRA SQL queries. I have the editor, is there any way to do that?



Like Ignacio Pulgar likes this

Hi @Rodri Alvarez ,

If you have the editor, then you just need to enter the source like shown in the screenshots here:

Then just use the Find and Replace fields shown in the second screenshot to substitute one version name with another one.


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events