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

[computerhighway]

The search box at the top of every layout does not find any result if the search word is not the first word of the name.

[yuri]

Try to use wildcard:

"%York" will find "New York"

[computerhighway]

Thank you, this is useful to know.

[hommelsheim]

Thats not a useful solution. For a developer is a % as search pattern normally, but for the standard user not.
How can i set the search pattern %pattern% as default search?

[tarasm]

I'm not sure that it's possible. It's a search standard for CRMs. Just teach your employees.

[Clintre]

I'm not sure that it's possible. It's a search standard for CRMs. Just teach your employees.

I've never had that as a standard in CRM and we looked at a ton of them. Having it default to being %query% is very common and used in many web apps now days. I have not looked under the hood, but wrapping a query team in wildcards %queryterm% should not be very difficult.

[Clintre]

Just to add to my post about you can add it to global search, fairly easily, by doing the following...

Open file application/Espo/Controllers/GlobalSearch.php

find

$query = $request->get('q'); 

add content below below

$query = trim($query, '%');
$query = '%'. $query .'%'; 

I do the initial trim in case someone has already added the wildcard to the beginning or end, since this makes it a global wildcard.

Now I have not looked at, nor do I know where the searches for individual plugins/pages are. However assuming it works in a similar fashion to the global search you could do the same thing. Took me about 5 minutes to find and add this and I did not have enough time to look for where the rest of the search calls were.

[Clintre]

Ok, after a little more time to research it looks like in addition to the above change that does a true wildcard search on Global Search, you can also do it on the record list as well by making the very simple change below...

Open file application/Espo/Core/SelectManagers/Base.php

Go to line 1248 and change...

$expression = $textFilter . '%'; 

to

$expression = '%'. $textFilter . '%'; 

Now please keep in mind I do not know the application well enough to know if this will cause any other problems. In my quick, but VERY limited testing it worked pretty well.

[tanya]

Don't forget that you can lose your modification after the upgrade... Try to put everything to the folder Custom

[Clintre]

Don't forget that you can lose your modification after the upgrade... Try to put everything to the folder Custom

Good point. Thanks

[peterberlin]

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

[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.

[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 ?

[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 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.