You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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.
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.
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,
@Stephen Sifers wanted to check in as well - I'm attempting to do the same thing here (filter a JIRA issue search given the value of a template variable) and can't find any easy way to do this (I'm using JIRA Cloud as well).
Is this on the roadmap? Is there any dev ticket I could follow / upvote?
Yet another document automation feature that is missing from Confluence it seems? I am trying to do the same thing, change the product of a Jira search query based on variables supplied when instantiating a template instead of finding all instances of a product within the page after applying the template and changing them by hand.