Variable Jira Filter Macro

scutrell November 15, 2024

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.

1 answer

0 votes
Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 16, 2024

Hi @scutrell 

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

scutrell November 16, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 17, 2024

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events