-
Bug
-
Resolution: Fixed
-
Low
-
None
-
Severity 3 - Minor
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
- run a CQL query that uses title=something OR title~something else.
- 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.
[AI-509] Content search API doesn't respect OR on ~ operator on title, text fields
| Component/s | Original: Search - Scaling [ 61411 ] | |
| Component/s | Original: Search - Core [ 46383 ] | |
| Component/s | Original: Ecosystem - API Framework [ 46317 ] | |
| Component/s | New: Search - Core [ 75296 ] | |
| Component/s | New: Search - Core [ 75296 ] | |
| Component/s | New: Admin Experience [ 74216 ] | |
| Key |
Original:
|
New:
|
| QA Demo Status | Original: Not Done [ 14330 ] | |
| QA Kickoff Status | Original: Not Done [ 14234 ] | |
| Project | Original: Confluence Cloud [ 18513 ] | New: Atlassian Intelligence [ 23110 ] |
| Component/s | New: Ecosystem - API Framework [ 46317 ] | |
| Component/s | New: Search - Core [ 46383 ] |
| Remote Link | New: This issue links to "Page (Confluence)" [ 530097 ] |
| Remote Link | New: This issue links to "Page (Confluence)" [ 530238 ] |
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Waiting for Release [ 12075 ] | New: Closed [ 6 ] |
| Remote Link | New: This issue links to "Page (Confluence)" [ 507794 ] |
| Description |
Original:
{panel:title=Status Update Oct 1, 2020|borderStyle=solid|borderColor=#4c9aff|titleBGColor=#4c9aff|bgColor=#fafbfc}
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 {panel} h3. 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) h3. Steps to Reproduce # run a CQL query that uses title=something OR title~something else. # the results will only match title=something h3. Expected Results The results match title=something or title~something else h3. Actual Results The results match only title=something h3. Workaround The only known work around is running the two clauses of the CQL query independently and aggregating the results. |
New:
{panel:title=Atlassian Update Oct 1, 2020|borderStyle=solid|borderColor=#4c9aff|titleBGColor=#4c9aff|bgColor=#fafbfc}
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 {panel} h3. 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) h3. Steps to Reproduce # run a CQL query that uses title=something OR title~something else. # the results will only match title=something h3. Expected Results The results match title=something or title~something else h3. Actual Results The results match only title=something h3. Workaround The only known work around is running the two clauses of the CQL query independently and aggregating the results. |
| Description |
Original:
h3. 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) h3. Steps to Reproduce # run a CQL query that uses title=something OR title~something else. # the results will only match title=something h3. Expected Results The results match title=something or title~something else h3. Actual Results The results match only title=something h3. Workaround The only known work around is running the two clauses of the CQL query independently and aggregating the results. |
New:
{panel:title=Status Update Oct 1, 2020|borderStyle=solid|borderColor=#4c9aff|titleBGColor=#4c9aff|bgColor=#fafbfc}
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 {panel} h3. 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) h3. Steps to Reproduce # run a CQL query that uses title=something OR title~something else. # the results will only match title=something h3. Expected Results The results match title=something or title~something else h3. Actual Results The results match only title=something h3. Workaround The only known work around is running the two clauses of the CQL query independently and aggregating the results. |
| Assignee | New: nmcginley [ nmcginley ] |
| Status | Original: In Progress [ 3 ] | New: Waiting for Release [ 12075 ] |