Fields and search groups in the repositories

Problem Description:

Can I have details on fields and search groups in the repositories?

• In the search fields: we can select both ‘Full text’ and ‘Fuzzy’: what happens with the mapping? Who has priority?

• In the search groups: there is only the ‘Fuzzy’ option and not the ‘Full text’ option, is there a reason?

Solution:

Without the full text option, all the words in a sentence are searched: thus, no link will be made between “Dubois” in the dataset and “Maurice Dubois” in the repository (it’s somewhat equivalent to using quotes in a Google search).

For search fields, there is no prioritization between ‘Full text’ and ‘Fuzzy’: the link will be made between “Duvois” and “Maurice Dubois” on the word “Dubois”, with obviously a lower level of similarity. So there is both word segmentation (for finding the largest intersection) AND tolerance for spelling differences.

For search groups, the full text option is implicit as we are searching simultaneously in several fields of the repository: we are therefore looking for combinations of words (e.g., first name + surname or company name + address).

Hint

If you want to search without full text across several columns of a repository, it is always possible to merge these columns before creating the repository, and make this merged column a search field without the full text option.