It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Populate JIRA Issues Macro with Variables (Template)

Hopefully someone has tripped over this and has a neat solution, I've been spending an inordinate amount of time reading through forums and posts and have not found anything.

My team and I create an Internal Release Notes document for each version release (I have created a template). However, we create these at the beginning of a release cycle, at the end of which there could be more or less issues (bug fixes for that release, etc.)

I've been trying to template this so that if the creator types in some variables (project ID, fixVersion) then the Jira Issues Macros would populate using pre-set queries needing just those variables. Having this work would be great, because I can also display particular fields in the table on top of the dynamic nature of this macro.

However, this does not seem to be a thing that is possible. I've even looked at addons but have not found anything that will do this for me.

Closest I've gotten is by pre-writing the query and then injecting it with wiki mark-up, but even that does not always work and requires manual intervention. Example: jiraissues:jqlQuery=project=$project and fixVersion=$jiraversion and affectedVersion is EMPTY|columns=Epic Link;Key;Type;Summary;QA Summary;Status;Labels;Linked Issues;Affected Department(s)|title=Stories|cache=off

Has anyone tried to do this and succeeded? I'll take anything short of writing a macro myself - I'm just not at the point to be able to do that quickly without significant help or time (or both). Additional blocker - we are on Confluence Cloud.

2 answers

0 votes

Hello MollyJo,

The concept of having pages that create based on dynamic values is something I really appreciate and can understand how helpful and versatile it would be to have. Out of the box, the product will not accommodate what you’re wanting to do (outside of How to document releases and share release notes). There are two options that come to mind, one is using an app with Confluence and the other is creating a custom blueprint for Confluence templates.

As far as apps go with Confluence, it would be possible to use a SQL macro to access data based on passed through values. This type of integration does not suit some instances due to easily access data across roles. However, it does allow you to access data very quickly. You can explore using SQL macros via a preset marketplace search for Atlassian Marketplace | SQL.

The other option will require some developer time to create a custom blueprint to use within Confluence which (depending on how you configure the blueprint) may allow for users to insert values and build the page based off of these values. More about blueprint may be found at Blueprints.

While not a direct answer on how to deploy your needed solution, I do hope the reference material proves helpful in exploring what additional options you have outside the base of the product.

Regards,
Stephen Sifers

Hi Stephen,

I'm not sure how much this would work against my configuration, as we are a Cloud installation as opposed to a server. I explored Blueprints, but they require more development knowledge then I can really spend time on learning in the immediate timeline, and it looks like most if not all of those SQL addons require the database to be hosted/managed by us.

Thank you though,

- Molly

Like Stephen Sifers likes this

Update.

This is now even worse with the new Confluence pages. Even ignoring the fact that variables are simply not working correctly at all, there is now no ability to pre-write the query I need and use wiki markup to quick manually switch it.

So this is completely unable to be automated.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

3,140 views 4 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you