Variable Jira Filter Macro

[scutrell]

I have a Confluence tracking page for tracking Jira tickets quarterly. It has a ton of Jira Filter Macros.

Unfortunately, every quarter - when the page is created, I have to go and update each macro to do nothing more than to change the date range.

In a perfect world, I would have to just update a page variable or something which would repopulate each filter with the new quarterly tickets.

Any thoughts on what options are available to me? At this point, I am half tempted to just automate the changes using Selenium or something, but it seems likely that there is a solution built-in to Confluence, and I'm just blocked by my own ignorance.

[Marc - Devoteam]

Hi @scutrell 

What are the filters you are using, between fixed dates or else?

[scutrell]

It is a JQL filter. Each of the dozens of macros have JQL specific to it, but the piece I would like to standardized so I would only need to change it in (ideally) one place is:

resolvedByDate >= 2024-01-01 and resolvedByDate < 2024-04-01

[Marc - Devoteam]

Hi @scutrell 

To update page options, will never update JQL filters.

You could use filter on a single page with option like resolved >= startOfMonth("-3") and resolved < endOfMonth("-1") this will always show the last 3 months.

This will always show the last 3 months resolved issues.

JQL has by default no startOfQuarter and endOfQuarter.

You could look at better reporting options in Confluence like Custom Charts for Confluence