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

[Clintre]

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

Good point. Thanks

[tanya]

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

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

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

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.

[tarasm]

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

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

[computerhighway]

Thank you, this is useful to know.

[yuri]

Try to use wildcard:

"%York" will find "New York"

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