Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-96153

Confluence uses the incorrect JQL when searching Jira issues on certain projects via Insert Jira Issue/Filter, which causes the search result to not be found.

XMLWordPrintable

      Issue Summary

      Confluence uses the incorrect JQL to search  Jira issues on certain projects via Insert Jira Issue/Filter. While the issue happens, Confluence uses "jql=summary...OR+description..." instead of using "jql=key" to search for the issue, which causes the search results not to be found. 

      This is reproducible on Data Center: (yes)

      Steps to Reproduce

      1. Install Confluence and Jira.
      2. Connect Confluence to Jira.
      3. On Jira,
        1. Create two projects following the Jira project key format: one named ABCD, and another named R2D2 for the project name and project key.
        2. Create at least one ticket on both projects, so there will be two issues, which are ABCD-1 and R2D2-1 to be searched. 
      4. On Confluence,
        1. Create a page > "+" (Insert more content) > Jira Issue/Filter
        2. Used ABCD-1 to search, the search result is successful as screenshot below.
        3. Used R2D2-1 to search, the search result shows No search results found as screenshot below.
      5. Check the HAR file to compare these two cases:
        1. Confluence use JQL below to search ABCD-1: 
          jql=key+%3D+ABCD-1
        2. Confluence use JQL below to search R2D2-1: 
          jql=summary+%7E+%22R2D2-1%22+OR+description+%7E+%22R2D2-1

      Expected Results

      Confluence should use "jql=key" to search every keyword so that the Jira issue key can be searched.

      Actual Results

      Certain keywords will be treated incorrectly like R2D2-1.

      Workaround

      For the single issue display, we can paste the URL of the issue directly onto the Confluence page. Confluence will auto-convert the link to a Jira Issues macro as mentioned in the document below:

      We can also specify "key=issue_key" while searching the issue key like below:

        1. CONFSERVER-96153_reproduce.mov
          15.09 MB
        2. image-2024-07-16-17-02-51-520.png
          image-2024-07-16-17-02-51-520.png
          28 kB
        3. image-2024-07-16-17-04-21-676.png
          image-2024-07-16-17-04-21-676.png
          30 kB
        4. image-2024-07-16-17-13-58-548.png
          image-2024-07-16-17-13-58-548.png
          32 kB

            [CONFSERVER-96153] Confluence uses the incorrect JQL when searching Jira issues on certain projects via Insert Jira Issue/Filter, which causes the search result to not be found.

            Jordan Anslow added a comment -

            A fix for this issue is available in Confluence Data Center 9.1.0.
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            Jordan Anslow added a comment - A fix for this issue is available in Confluence Data Center 9.1.0. Upgrade now or check out the Release Notes to see what other issues are resolved.

              05a8667aef42 Saquia Naz
              9dd52b4ca361 Brent Lin
              Affected customers:
              1 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: