Having an issue with the JIRA Issue Macro not showing data in tables

Question

When setting up the JIRA Issue macro I receive the following error message for JQL or for a filter:

"The Jira server didn't understand your search query. If you entered JQL, please ensure that it's correctly formed. If you entered an issue key, ensure that it exists and you have permission to view it.".

1) I can see the data if I run the query within JIRA

2) I can use the same JQL or filter within a Jira chart in the same macro and the data renders correctly without the error

3) I have tried the workarounds in this ticket: https://jira.atlassian.com/browse/CONFCLOUD-65911

Any thoughts on next steps for troubleshooting this?

Greg Williams_nvfbk4 · Answer

We we're getting the same issue and have a workaround (if you have more than one tenant linked):

EDIT: We're on Jira Cloud so result may vary

* In the dropdown to the right, choose another tenant (any will suffice, in this instance, System Jira is the intended target):

* Go back to the dropdown to the right and re-select the targeted tenant (in this instance, System Jira is the intended target):

* Re-enter your search and the results should appear:

Larry_99nvdq · Answer

this didn't seem to address the issue on the first try.  We are going to try in our  test environment to give us some additional troubleshooting flexibility.

Ivan Lima · Answer

@Larry , I've seen similar discussions to this one before. Have you followed the steps on the article Confluence Issue Macro not able to display issues from JIRA? This probably will help you here or at least it will give you some insights.

Cheers,

IL