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.
Hi @scutrell
What are the filters you are using, between fixed dates or else?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.