Populate JIRA Issues Macro with Variables (Template)

MollyJo Tighe

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= and fixVersion= 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.

Stephen Sifers

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