Using the full text search

Searching in text fields in clients is performed via a full-text index, but only if the administrator has defined the corresponding settings in the Management Console.

How does it work?

• From all data records in CAS genesisWorld, all words from text fields are collected in a special list of the database, the full-text index.
• Any search terms which have been entered into the list will be searched for.
• Words such as "the", "a", "an" and so on are treated as stop words and are not considered to be search terms.
• The search always begins with the begining of the search terms. If the start of a word is unknown, then you should use a placeholder such as a percentage sign at the begining of the search term
• When entering multiple search terms, the order you use is irrelevant.
• Often the number of hits is higher, because multiple text fields are searched simultaneously.
• Filter conditions are not influenced when searching with the full-text index. Using filter conditions for a text field with the contains condition is very similar to using a full-text index search.

Where is the full-text index used?

If the search with the full-text index is enabled, then this is used for all searches in text fields in CAS genesisWorld, for example,

• in the Desktop Client,

in the Search window and on the Search tab,

in the search field on the toolbar,

in the dossier and in templates,

when filtering via lists,

• in portals or
• in mobile clients.

In the recycle bin view, the full-text search is not used.

Possible settings in the Desktop Client

• You can switch active searches using a full-text index on and off in the Settings window via the Classic search option in the Desktop Client.
• In the Settings window, you can also define which fields and combinations of fields in the Search window are included in the Fields to search in drop-down list.

• When filtering via lists, users can select the text fields for the search.

Dependency of database systems

Searching using the full-text index in CAS genesisWorld is based on the default options of the CAS genesisWorld database system and as a consequence, the following specifics can occur.

• With the Microsoft SQL Server Express Edition database system, the full-text index search is not possible.
• If you use Microsoft SQL Server as a database system, the full-text search must have been installed in the respective database instance. The corresponding service must be activated for the database.
• When using Microsoft SQL Server as your database system, the word stems for verbs and wort limits for the search are taken into account.

If you search for auto, Auto is a word of its own and you will find an address for Westautomatik GmbH.

If you are searching for vemi then the address Devemit GmbH will not be found. In this case, you need to use the search term %vemi.

Word boundaries and word stems are different depending on the language and are thus also dependent upon the database language being used by CAS genesisWorld.

• Search results can vary depending on the what version of Microsoft SQL Server you are using.
• For more information consult your respective documentation on the subject of full-text searching for the database system you are using.