Use of User Macros in a Confluence page to set a variable that JQL queries would get

Sergio Montávez

Hi,

I need to create several Filters with the same ID (but different JQL queries) to be shown in the same Confluence page. I would like to set the ID (manually) through the Confluence page so the Filters automatically gets the value from it and I thought about using User Macros, but haven't found it in the documentation, is this a feasible idea?

This would be the picture:

Confluence page

A variable $filter_id exists in the page and is set by the user, i.e.:

 $filter_id = 123

 

Filters gadget in the same Confluence page

Filter A:

id = $filter_id AND Sprint = 32

Filter B:

id = $filter_id AND Sprint = 33

Filter C:

id = $filter_id AND "Issue Type" = Bug

 

I don't want to create another filter containing the id because this ends up doubling the amount of Filters and it's not scalable.

 

Thanks a lot!

Diego_88dj6o

Hey there!

Sergio, this is quite an interesting objective you have in hands!

Some time ago, other admins have achieved this here with the Community. You can check their (quite complex) outcome here:

Can I use a variable with a macro? I am trying to create a custom template and use variables and a JIRA macro together.

The solution was provided by another admins there on that thread. It is very well documented on his reply though, worth a check!

Hopefully this helps you out Sergio. Let us know.