Search function does not find any results for words in the middle of name field.

[wtconseil]

For me, this settings in config.php is working nice...
and regarding the code : https://github.com/espocrm/espocrm/b...Base.php#L2092
it adds wildcard before and after..

sorry for the smiley, they were not sarcastic.
That's strange to apologize for that on a forum where people should help each other... but ok. I prefer to leave this thread right now and avoid losing my energy

[bandtank]

You can also add 'textFilterUseContainsForVarchar' => true, in config.php

That doesn't fix this issue. As an aside, I really loathe smiley faces. They seem so trite and sarcastic.

[wtconseil]

You can also add 'textFilterUseContainsForVarchar' => true, in config.php

[mmandell]

What is the change you made to config.php and does this survive upgrades?

[alasdaircr]

This class has a nice combination of using relevance values from a full text search and soundex values for mispelled words. https://github.com/shannah/xataface/...Index.php#L122

For the fields which are selected as text searchable in EntityManager, every update causes the index to be updated with soundex values for the words in the field. Then searching involves comparing prestored soundex values.

[alasdaircr]

Partial string searches are only slow when a real cache layer is absent. I added a Redis cache to my EspoCRM installation by modifying the most common searches to look in the cache first.

How would one add the %query% search to the custom folder? I don't understand the file structure yet, so I'm not sure where to put it or how to do it.

Hi - old thread - but is your redis support available online somewhere to look at?

I'm thinking about working on fuzzy searching involving soundex values and an index table, having redis to cache common queries would make things a lot quicker.

[tanya]

No list. The most looks like https://github.com/espocrm/espocrm/issues

[MatLudlam]

Fantastic news. I think that will greatly improve the usability (and speed).

Looking forward to it.

Thanks

PS - is the list of future things published anywhere?

[tanya]

Hello

EspoCRM requires MySQL 5.1 or newer. Full Text Search is available from 5.6 version.
Full Text Search feature is planned for the end the year

Thanks

[MatLudlam]

I think that changing the query to have % either side of the search text is not really the answer. As pointed out already this is very slow, does not scale and requires user training.

MySQL provides a special sort of index for solving this problem and it works very well. This does require extra indexes to be created and the SQL within the application has to be modified, but the result would be fantastic.

I am sure we all have a list of places where we would like this. My recent addition is the text within the body of Knowledge Base items so that I can find the right one.

For reference I have 250,000 emails indexed in a MySQL database and using this I can find all occurrences of "amy" in a few seconds.

The link below (not sure how to use this forum correctly) is to the MySQL documentation on full text indices.

[alasdaircr]

It was a patch to core, it's not possible in the custom folder. However I'm not using this anymore, I just use the config.php flag mentioned in the other thread you replied to.

[bandtank]

It's because text searching is slow, so if you have 10,000's of records it can slow down the queries.

I patch the % in to all text queries as my users have no concept of search modifiers and just expect everything to work like google.

It could be a configurable option in the Admin section ?

Partial string searches are only slow when a real cache layer is absent. I added a Redis cache to my EspoCRM installation by modifying the most common searches to look in the cache first.

How would one add the %query% search to the custom folder? I don't understand the file structure yet, so I'm not sure where to put it or how to do it.

[alasdaircr]

It's because text searching is slow, so if you have 10,000's of records it can slow down the queries.

I patch the % in to all text queries as my users have no concept of search modifiers and just expect everything to work like google.

It could be a configurable option in the Admin section ?

[Clintre]

Why this solution is not integrated in the standard.? This saves typing%.
peter

I don't know, it would make sense and is how most systems work now days. Such a simple fix.

[peterberlin]

Why this solution is not integrated in the standard.? This saves typing%.
peter