way to automate this so those filters always update for the current week?

[Venugopal Paladi]

We have a weekly meetings where the company leadership reviews production development and system changes to ensure all parties are aware of potential major changes.

My manager makes the confluence notes each week copying them from the last meeting.

So we have jira filters in place that shows Active/live tickets that are in specific statuses.

This works well for the actual meeting but however, the filters are dynamic and change over time - in order to record what was done that week, we manually key in the ticket list. It's not good since they don't reference to actual tickets/pages (Don't have time on the call to make these links)

So is there any way to automate these filters target the tickets within that specific week?

Version 8.13.10 Data Center

Thanks

Venugopal Paladi

[Katerina Kovriga _Stiltsoft_]

Hi @Venugopal Paladi ,

You may check this Community thread:

• in the first part I suggest using live filtration for the Jira Issues macro (our Table Filter and Charts for Confluence app allows you to filter and aggregate Jira issues on the fly from the view page mode without changing the JQL). You may even create live Jira dashboards right in Confluence - please check the examples here;
• the last answer mentions how to extract historical information from the Jira Issues macro (not the current state, but for the previous time period).

Maybe this helps your case. 

[Tessa Tuteleers]

Hi @Venugopal Paladi , 

please try the following JQL: 

status was in ("In Progress", Backlog) DURING ("2021/01/01", "2021/02/01")

Where you can add the needed statussen and from-to dates. 

Cheers, 

Tessa