Full Text Search

Full-text search provides several options to precisely define search queries and narrow down results. The following features can be used individually or combined, depending on your use case.

When typing a word into the search field, you get suggestions where you can pick from or simply continue writing (for more details see below):

OPTION	EXPLANATION
Fulltext	Automatically adds wildcards left and right.
Exact Match	A case-sensitive search that only finds records where the whole value of a field match.
Word Suggestions	Shows words from the index and searches without wildcards.
Lists	Shows entries from lists, vocabularies and thesauri.

Searching for a Specific Word

Case Sensitivity

By default, full-text search is case-insensitive. This means that search results are returned regardless of capitalization.

Examples:

• report, Report, and REPORT return the same results.

• Searching for programmfabrik also matches Programmfabrik.

A case-sensitive search is only possible with the exact search (see below).

Exact Search

The exact search allows you to find records where a specific field matches exactly the search term you enter. This type of search is case-sensitive and does not return partial matches or variations (add wildcards to achieve this).

If the field contains fylr documentation:

Search Term	Result
`FYLR`	❌ No match
`fylr documentation`	✅ Match
`documentation`	❌ No match
`Fylr Documentation`	❌ No match
`fylr*`	✅ Match

Phrase Search

Phrase search allows you to search for an exact sequence of words. The words must appear in the specified order and directly next to each other.

To perform a phrase search, enclose the phrase in quotation marks.

Example:

"Berliner Fernsehturm"

This search returns only records where the complete phrase appears exactly as entered.

Notes:

• Case sensitivity is ignored.

• No additional words may appear between the phrase terms.

• Phrase search is especially useful for quotes, fixed expressions, or known text fragments.

Boolean Operators

Boolean operators allow you to logically combine multiple search terms.

KEY	SEARCH OPERATOR	EXPLANATION
- or !	NOT	The following search term is searched with “Not”.
+	AND	The following search term is combined with “And”.
,	OR	The following search term is combined with “Or”.
(	(	Parenthesis for logical groupings.
)	)	Parenthesis for logical groupings.

AND

The AND operator returns only records that contain all specified terms. It is not necessary to use the AND operator explicitly. By default, all search terms are automatically combined using an implicit AND. Therefore, records will only be returned if they contain all specified terms.

Example:

contract AND termination

Result: Only records containing both contract and termination.

OR

The OR operator returns records that contain at least one of the specified terms.

Example:

invoice OR receipt

Result: Records containing invoice, receipt, or both.

NOT

The NOT operator excludes records that contain a specific term.

Example:

report NOT draft

Result: Records that contain report but not draft.

Combining and Grouping Operators

Boolean operators can be combined and grouped using parentheses.

Example:

(contract OR agreement) AND termination

Wildcard Search

Wildcard search allows you to find terms when parts of the word are unknown or variable.

Single-Character Wildcard (?)

The question mark ? represents exactly one arbitrary character.

Example:

Ma?er

Matches, for example:

• Mayer

• Maier

• Mauer

Notes:

• Each ? replaces exactly one character.

• Multiple ? characters can be used within a single term.

Multi-Character Wildcard (*)

The asterisk * represents zero, one, or multiple characters.

Examples:

Auto*

Matches:

• Auto

• Automatic

• Automobile

*report

Matches:

• annualreport

• auditreport

Notes:

• The * wildcard can be used at the beginning, middle, or end of a word.

• Searches with a leading * may impact performance.