Performing text searches using CQL
A query is broken up into terms and operators. There are two types of terms: Single Terms and Phrases.
A Single Term is a single word such as "
test" or "
A Phrase is a group of words surrounded by double quotes such as "
Note: All query terms in Confluence are case insensitive.
Confluence supports modifying query terms to provide a wide range of searching options.
On this page:
Wildcard searches: ? and *
Confluence supports single and multiple character wildcard searches.
To perform a single character wildcard search use the "
To perform a multiple character wildcard search use the "
The single character wildcard search looks for terms that match that with the single character replaced. For example, to search for "
text" or "
test" you can use the search:
Multiple character wildcard searches looks for 0 or more characters. For example, to search for
WindowsNT you can use the search:
You can also use the wildcard searches in the middle of a term. For example, to search for
Windows95 you can use the search
Fuzzy searches: ~
Confluence supports fuzzy searches. To do a fuzzy search use the tilde, "~", symbol at the end of a single word term. For example to search for a term similar in spelling to "
roam" use the fuzzy search:
This search will find terms like foam and roams.
Note: terms found by the fuzzy search will automatically get a boost factor of 0.2