Uploaded image for project: 'Atlassian Intelligence'
  1. Atlassian Intelligence
  2. AI-509

Content search API doesn't respect OR on ~ operator on title, text fields

    XMLWordPrintable

Details

    • Severity 3 - Minor

    Description

      Atlassian Update Oct 1, 2020

      Thank you for your patience. This issue has been fixed for the title field. The remaining fix is expected to be released in the next few days.

      Warm regards,
      Elaine Hankins, Confluence Cloud Product Manager

      Issue Summary

      When OR operator is used on the title field with the tilde fuzzy match operator, results are not returned from both clauses. If one clause is exact match =, then the results will be from the title= search. If both clauses are ~, results will be returned from the first clause. 

      When I run https://ecosystem.atlassian.net/wiki/rest/api/search?cql=title%20~%20test I get a totalSize of 142
      When I run https://ecosystem.atlassian.net/wiki/rest/api/search?cql=title%20=%20new I get a totalSize of 39
      When I run booth in the same query https://ecosystem.atlassian.net/wiki/rest/api/search?cql=title%20~%20test%20or%20title%20=%20new I get a totalSize 25 Shouldn’t be more than 142? Looks like it have something to do with the use of ~
      If I use = instead it seems to work.
      When I run https://ecosystem.atlassian.net/wiki/rest/api/search?cql=title%20=%20test I get a totalSize of 133
      When I run https://ecosystem.atlassian.net/wiki/rest/api/search?cql=title%20=%20new I get a totalSize of 38
      When I run booth in the same query https://ecosystem.atlassian.net/wiki/rest/api/search?cql=title%20=%20test%20or%20title%20=%20new I get a totalSize 170 which feels like the right number (One page with both test and new in the title 133 + 38 = 171)

      Steps to Reproduce

      1. run a CQL query that uses title=something OR title~something else. 
      2. the results will only match title=something

      Expected Results

      The results match title=something or title~something else 

      Actual Results

      The results match only title=something

      Workaround

      The only known work around is running the two clauses of the CQL query independently and aggregating the results. 

      Attachments

        Issue Links

          Activity

            People

              nmcginley nmcginley
              nmcginley nmcginley
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: