Would like to get a value from a table to insert it into other macros

Question

Hi,

I would like to know if it's possible to get the value from a place in a page (title, page properties, table...) and update others macros with this value (example : Jira macro).

Usage :  I use Confluence for a dev team and we use in differents places Jira macros with always the same key. So instead of repeat the key number in each macro, I would like to create a template with a wizard and when we create the page, we insert the jira key in a single place, insert informations at the differents others places and then when I publish my page, the macro will show the correct information based on the key introduce in a single place.

In advance, thx for your help.

Patricia Mayer · Answer

Hi, I'm trying to do something very similar, however we use Confluence Cloud version, can this be done please?

Dominic Lagger · Answer

Hi @Guillaume Lorquet We had to find a solution for a similar problem. We have more than 10 JIRA filters for checking our release. And on each of these filters, we have to change the "fixVersion" every single time, we release, in more than 10 JIRA macros... So we made a user macro, where you just have to search & replace the "fixVersion". The user macro looks like this: ## Macro title: JQL Query in Body ## Macro has a body: Y ## Body processing: Rendered ## Output: JIRA Issues based on Jira Macro ## User Macros laufen auf der Apache Velocity Engine ## http://velocity.apache.org/engine/1.7/user-guide.html ## ## Modified: ## This macro can be used with injected template-variables ## @param maxRows:title=Max Rows|type=int|required=true|default=20|desc=Enter the max rows, anything above 1000 will only display 1000 rows. ## @param columns:title=Columns|type=string|required=true|default=type,key,summary,status,assignee|desc=Enter the columns you want returned. Must be separated by commas, all lowercase, and no quotes. e.g. key,summary,assignee,test author,reporter ## @param displayJQL:title=Display JQL|type=boolean|required=true|default=false|desc=Displays the JQL in an Info Box under the Result Table #set ($body = $body.replaceAll(""

",""")) #set ($body = $body.replaceAll("

"",""")) #set ($body = $body.replaceAll("\Q

\E"," ")) #set ($body = $body.replaceAll("\Q

\E"," ")) #set ($body = $body.replaceAll(""",""")) #set ($body = $body.replaceAll(""",""")) #set ($body = $body.replaceAll("\Q\E"," ")) #set ($body = $body.replaceAll("\Q\E"," ")) #set ($body = $body.replaceAll(""

","""))
#set ($body = $body.replaceAll("

"",""")) #set ($body = $body.replaceAll("\Q

\E",""))
#set ($body = $body.replaceAll("\Q

\E","")) #set ($body = $body.replaceAll("\Q
\E"," ")) #set ($body = $body.trim())

JIRA $paramcolumns $parammaxRows $body ff94f833-c264-3d1f-a236-7bdb5d13106c

#if ($paramdisplayJQL=="true")

$body

#end So you can set your JQL and it's shown in the edit mode. Therfore you just have to search & replace your issue number. Hope this helps. Regards, Dominic

Shannon S · Answer

Hello Guillaume,

Thank you for explaining your requirements.

Since you are using Confluence Server, you could do this with a user macro.

There are a few threads below where users had similar requirements and they created a user macro for this:

* Solved: How do you add template variables as macro parameters or in plain text macro bodies? 
* Solved: Using template variables as input parameters to jira gadget

Have a look there, as it may be able to help you with your requirements.

Regards,

Shannon