Bulk Update Multiple JIRA Filter/Issues inserted in a Confluence Page table

Question

I have a Table, which has Dates in the column and Issue topics in the Rows.

For each cells we have a JIRA search query which is inserted as a JIRA Filter. This JIRA filter queries and displays the number of tickets matched.

Now, the task is to update the dates of JIRA query everyday and insert in the new Date column. In the JIRA search query only the Date is changed.

In the present scenario, we have to open individual JIRA Filter, edit the search query, then insert it.

Is there any way to Bulk update this task ?

Liam Green · Answer

Hi @Ashutosh Mohanty

This article will show you the different advanced functions.

If you're adding data every day then you will need to edit it daily - if you just wanted 5 columns to show the last 5 days, for example, then you could use StartofDay(-1) to show yesterday, continue that to use up to StartofDay(-5) and the data in each column will change daily.

Ashutosh Mohanty_6b8dsi · Answer

Hi @Liam Green , Thanks for your suggestion. I will try out your advice, hope that solves it ! Is StartOfDay() a jira filter query function that returns the current date ? My Jira filter query is somewhat like this : status != Cancel AND summary ~ store-inventory_consumer_group_api AND labels = Production AND Markets in (Singapore, Australia, Philippines, Indonesia, Malaysia, Vietnam, Thailand) AND "Platform/System(ACPF)" = "ACPF StoreInventory" AND created >= 2021-06-10 AND created <= 2021-06-11 AND reporter in (eva.aism) Now, for the entire column for a day, this query will be same with some modifications other than the date parameter. Everyday, i have to copy the filter from previous day and paste in the new date-column and update the date parameter individually for the entire column again. created >= 2021-06-11 AND created <= 2021-06-12 My aim, is to use any function where i don't have to edit the dates everyday, and it would take automatically using any built-in function. Thanks.

Liam Green · Answer

Hi @Ashutosh Mohanty

Welcome to the Commmunity!

One option here would be to use the 'StartofDay()' time period, then add a new column to the left each day with tickets from the day before.  I've outlined what I mean below:

Today you would have one column with 'StartofDay()' in the filter

Tomorrow. you would add a column to the left with 'StartofDay(-1)'

This way, each column would update automatically and you'd just need to change your dates at the top.

Hope that helps,

Liam