Wildcard option / check on search

[Clintre]

Although I have a coding work around and I understand some of the logic behind not doing wildcard searches example %searchterm%, a good compromise would be to have either a check box next to the search field to be able to perform wildcard searches. Make it an setting on the back end for those of us that want to enable it for our users.

I have never used a CRM that did not have wildcard searches and it has been frustrating to our users.

[tanya]

Hello

There you can find an interesting information about search

Couple of things.

'%petr%' will never return results containing peter. That's just how SQL works.

Espo already allows you to do this using the varchar 'Contains' filter modifier in list/report view.

To enable '%<term>%' support in all the search boxes add

'textFilterUseContainsForVarchar' => true

to your data/config.php file.

http://forum.espocrm.com/forum/feature-requests/21188-search-engine-improvements

[Clintre]

Yes, I understand that. However that is not end user friendly and is the biggest issue across our user base. Most systems like Salesforce and other systems have this option and it is pretty standard with SaaS solutions as well.

[alasdaircr]

Just edit the file data/config.php on your server and add 'textFilterUseContainsForVarchar' => true

then all text searches will use wildcards. Seems pretty simple to me...

[bandtank]

Just edit the file data/config.php on your server and add 'textFilterUseContainsForVarchar' => true

then all text searches will use wildcards. Seems pretty simple to me...

It didn't work very well in my case. Phone numbers weren't being searched correctly or at least with both wildcards. I had to edit the source code even though I put the phone number field in the text search declaration area in the appropriate json file.

[alasdaircr]

Sorry I'm not following what you're saying - but if you find a bug create a new thread or gitthub issue. If you make changes you should show them, then people can understand what it is you're doing.