Deleted Issues in Jira Project shows up in Confluence page using Jira Issues Macro

[Sanjay Khanna]

Hello, I deleted some of the Jira issues from my project. These issues were reported on Confluence page using Jira Issue macro. I deleted these issues in Jira however the Confluence page with Jira Issue macro still show them in the report. Its not removing them from the report.  

We are using Premium Jira version on Free Trial. 

[Joe Pitt]

I use the Jira macro in Confluence with no problems. However we're on paid versions. I suggest opening an issue with Atlassian about the Confluence problem, providing you are paying for Confluence. 

[Sanjay Khanna]

Then what is the purpose of Free Trial? If it doesn't work in Free Trial it won't work in paid version either.

[Walter Buggenhout]

Hi @Sanjay Khanna,

That very much looks like an issue with refreshing the result set. Try refreshing the macro or - in edit mode - refresh the filter and save your page again. It's not what you would expect, but it may act as a workaround to - probably - fix your view of the correct issues in Confluence.

Hope this helps! 

[Sanjay Khanna]

I tried refreshing the macro in edit mode and it didn't work. I have 10 tables using this macro in Confluence and this doesn't seem to be the solution for managing 20 epics in the project as PM will be editing, deleting and updating issues in Jira. 

[Sanjay Khanna]

I deleted and recreated the table in Confluence and it still doesn't work. 

[Walter Buggenhout]

I have seen results in a Jira macro not correctly refresh in the past, @Sanjay Khanna. If that is so, that may qualify as a bug or at least an opportunity for improvement. I can't fix that for you.

What I can try to help you with is to work around the issue so the deleted issues no longer appear.

You've got me confused about the tables you mention. And they should not have any relevance to the problem here. Just for the sake of making sure we are solving the right problem and solving it in the right way, take these steps:

• Take the exact filter that is now attached to your Jira macro in Confluence and copy it to Jira, in Filters > View all issues.
• Run the filter there and make sure your deleted issues are no longer there.
• Back to Confluence, add a new Jira macro to you table and add the filter there.
• Run the filter in Confluence and again, check if you see the same results as in Jira

I would expect that you get the exact same results in step 2 (Jira) and step 4 (Confluence). If that's the case, replace your outdated Jira macro with the new one where needed. If not, you might want report this to Atlassian support directly.

On a side note: it's quite logical that you edit and create issues in Jira. As a best practice, I would recommend not to delete issues in Jira, but instead move them into a closed status (use the resolution field to indicate you've decided not to complete the work). Not because of this issue, but because deleting issues is literally destructive and leaves no trace of whatever was there. And Jira can perfectly handle hundreds of thousands of issues, so there's really no reason to physically delete them. 

[Sanjay Khanna]

What I meant by table is the essentially the table Jira Issue marcro creates when it runs the JQL. 

[Sanjay Khanna]

Thanks! I have opened support ticket for this.