Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-65911

"JIRA Issue/Filter" macro search breaks when using a valid JQL query

    XMLWordPrintable

Details

    Description

      Summary

      When using "JIRA Issue/Filter" macro users get an error when running a valid JQL query. Running the same JQL query on Jira correctly returns issues, but when trying to use this exact same query on "JIRA Issue/Filter" macro, the search do not return any results and throws the following error:

      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. Learn More

      Environment

      • Using "JIRA Issue/Filter" macro, when adding a query containing either "WAS" (e.g. "Status WAS "In Progress"") or "CHANGED TO" (e.g. "Status Changed TO "In Progress"").
      • It seems that currentuser() is affected by this BUG on "Assignee was currentuser()" and "Assignee changed TO currentuser()"
      • On Jira these JQL queries run like a charm, but running these queries on "JIRA Issue/Filter" macro breaks the macro and the error message above is displayed.

      Steps to Reproduce

      1. Insert "JIRA Issue/Filter" macro into a page;
      2. Run a JQL query on Jira containing one of these terms, for example " Status WAS "In Progress" ";
      3. Run the same query on "JIRA Issue/Filter" macro.

      Expected Results

      • Query should run as expected and results should be displayed exactly like Jira's results

      Actual Results

      • No issue is returned and an error is displayed:

        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. Learn More

      Notes

      This behavior seems related to CONFCLOUD-65276 and CONFSERVER-57861

      Workaround

      There are currently thee workarounds for this BUG.

      1st workaround:

      Changing "WAS" to "WAS IN" seems to solve this issue - e.g. "Status WAS IN ("In Progress")";

      2nd workaround (recommended):

      Adding another TRUE statement to the JQL query seems to solve this issue (any true statement that won't change the result of the query search will do). For example changing "Status WAS "In Progress"" to "Status WAS "In Progress" and project != empty" correctly returned the desired results.

      3rd workaround:

      Saving this JQL search as a new filter in Jira, and instead of using "JIRA Issue/Filter" to search for issues, use instead "Filter Results" Macro > select the newly created filter.

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              halegra Helton A. (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: