Issue with advanced cql search and finding pages by title

Confluence Development Confluence Cloud
,
1

Hello

I have an issue with the advanced search CQL getting page details defining the page title.

Only for some specific words(probably only articles) the search returns weird results

Some of the words I am sending are the following. (“The”, “On”, “By”)

Examples of the urls and the results.

Example 1. Returns every page

Url → https://testing.atlassian.net/wiki/rest/api/content/search/?cql=type=page AND space IN (“QUAL”) AND title ~ “the”

I have created the pages with the following page titles

  1. “The test page 1”
  2. “Permission page”
  3. “Custom page”

Expected Results → Only pages with a title that contains the word “the” like page number 1.

Actual Results → All the previous pages.

Example 2. One page is missing

I have tried using a wildcard search with the asterisk ( * )

Url - > https://testing.atlassian.net/wiki/rest/api/content/search/?cql=type=page AND space IN (“QUAL”) AND title ~ “th*”

I have created the pages with the following page titles

  1. “The page 2”
  2. “Thee”
  3. “Thee page”

Expected Results → Returns details for those pages

Actual results → I am gettings results only for pages 2 and 3.

Thanks.

1 Like
2

@VakalosMixalis,

I think this is all documented behavior according to Confluence search syntax. You are running into what the documentation calls “stop words”.

1 Like