search filter n̶o̶t̶ ̶w̶o̶r̶k̶i̶n̶g̶ ̶p̶r̶o̶p̶e̶r̶l̶y̶ (edited)

[sapyantuk]

HelloTeam , when i search in entity only first letter are filtering

for example

i have record with name : Ebanking of Espo Bank

if i search Ebanking it will show but if i search Espo Bank it wont show the record .

how can we filter any words in search bar

thanks in advance

[yuri]

https://docs.espocrm.com/user-guide/text-search/#list-view-text-search

Options:

• Use * wildcard.
• Force 'contains' search in settings.
• Enable full-text search.

[yuri]

Please do not use misleading topic names.

[Maarten]

I have a related question.

I have an organization with the name Ethiopian Bank
I have the 'contains' setting enabled
I have full text search enabled in Organization on field Name.

If I search for Ethiopia (without the n), it doesn't find the organization Ethiopian Bank.

I know it can be solved with Ethiopia*. But this requires the user to be aware of search parameters.

Is there a way to get partial matches from search queries?

[yuri]

There's no such an ability. When Fulltext Search is enabled, the wildcard is not appended to the text search query. You can customize it though.

[llsatellite]

Is there a way to keep "%" by default value on the search bar so we don't have to input all the time