CQL Search Returns Incorrect Results for Page Titles in Confluence Cloud

XMLWordPrintable

    • 1
    • 5

      Issue Summary

      When using Advanced Search with CQL in Confluence Cloud, queries for exact page titles do not return expected results, affecting automation and add-on functionalities.

      This issue affects automation rules in Jira and Confluence where actions depend on CQL to find specific parent pages. Despite using the exact page title "Releases", the automation fails due to incorrect search results. Additionally, any add-ons relying on CQL for similar searches might also face disruptions.

      Steps to Reproduce

      1. Create pages with titles "Releases", "Release 1", "Release 2", "Release 3" and so on in a space.
      2. Perform a CQL search using the following query:
        /wiki/rest/api/content/search?cql=title%20~%20%22Releases%22%20and%20space%20=%20<SpaceKeyHere>
      3. Observe the search results returned by the API.

      Expected Results

      The search should return the page with the exact title "Releases" and any other pages containing the word "Releases" in their title.

      Actual Results

      The search returns pages with titles containing the word "Release" but does not include the page with the exact title "Releases".

      Workaround

      To temporarily resolve the issue for automation:

      1. Rename the page titled "Releases" to a unique title.
      2. Set up the automation rule using this new unique title.
      3. Once the rule is configured and saved, rename the page back to "Releases".

            Assignee:
            Nora McGinley
            Reporter:
            Dhanush
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: