How to get Jira issue query filter in Confluence to update on loading page

[Amy Cufflin]

hi there

I have created a RAID matrix in Confluence. It's a 5 x 5 grid, and in each cell, I have a JQL filter query search to pick up Jira issues with the relevant impact and likelihood scores. An example query is:

project IN ("DO", "TSRMI", "TSRRME") AND issuetype IN (Risk, Issue, Assumption, Dependency) AND "Impact[Dropdown]" = 3 AND "Likelihood[Dropdown]" = 5

This works just fine initially, but when I reload the page, I was hoping it would refresh each query, so that the page would always highlight the current highest risks. I've changed the impact and likelihood of several individual tickets, but the search results on the Confluence page have not updated to reflect those changes.

What have I missed please?

[Trudy Claspill]

Hello @Amy Cufflin 

Welcome to the Atlassian community.

Are you using the native Confluence Table macro or some other feature/macro to create your table?

Are you using a Jira macro within the cell? If so, which one?

Are you using and explicit JQL statement like you showed, or a "filter = <filterId>" statement?

[Amy Cufflin]

Hi Trudy

Thanks for replying.

I created the table using the only way I know how - using the table button in the standard menu bar. 

I am using the Jira Work Items macro to create each filter, and each one is an explicit JQL statement. Should I be creating and saving the filters in Jira first and then using Jira IDs for each? If so, how would I do that?

Many thanks in advance for your help!

[Trudy Claspill]

I don't recommend creating and saving the filter in Jira and using the filter ID in Confluence. There is a known lack of refresh of the data in that situation.

When you say you reload the page are you doing a refresh of the browser tab or clicking on the page link from elsewhere in Confluence?

From my experimentation doing a refresh of the browser tab will cause the Jira filters to refresh, but re-navigating to the page within Confluence does not. Confluence uses caching of page information to speed up page loading, so simply re-navigating to the page will not necessarily refresh all the content of the page, it seems.