Full text search

[mgielda]

Hi,
It's me again - I just noticed that all searches in Espo only search entities which start with the search string, and was wondering if it is possible ro do a full text search? Often tasks are named after e.g. a company (for example: arrange a meeting with XYZ), and the company name (XYZ) cannot be used to search the tasks to find the one you are looking for. This is a fairly common use case I believe?

Could full text search be activated somehow or is it a not-yet-implemented feature?

Best regards,
Michael

[yuri]

Hi

You can prepend '%' to your search phrase. It's made for a sake of performance.

[mgielda]

Thank you very much, you are most helpful. Indeed, this works very well.

Cheers,
Michael

[lamvnd]

Hi

You can prepend '%' to your search phrase. It's made for a sake of performance.

How to do that as default?

[yuri]

application/Espo/Core/SelectManagers/Base.php

find the needed line and prepend % there.

[emillod]

Can you tell me in which line i need to put % ?

[peterberlin]

If you can turn % on and off, everyone can decide for themselves if he likes the performance.
Peter