Search only finds if search string is first word in record title.

[madmat]

Maybe someone else has similar problems, I couldn´t find anything in the forums.

Using the global search function in the upper right corner I only get results if the search string matches the first word of a record title.

"Project World Domination"

If I search "World" or "Domination" results are empty, search string "Project" succeeds.
This applies for modules Projects, Cases, Bugs.
Contacts & Accounts work fine afaict.

Any ideas?

Sugar: 5.0b
Server:Win2k3
Browser: FF & IE7

[Angel]

I believe this is normal behavior of the search function.

If you want to search for something like "World", you could do so by using '%World" as your search string.

The percentage symbol is the wildcard you will want to use in that case.

[madmat]

*smackmyhead*

ok, I did try *World* and so on with "*" as wildcard.

Thank you!

[heta]

Hello madmat,

if u want to change the condition in code itself... you can find it @ modules/Home/UnifiedSearchAdvanced.php

search for

$clause .= "LIKE '{$_REQUEST['query_string']}%'";

and add % before {

and see the result..

If works, thats Good...

[madmat]

Hello madmat,
if u want to change the condition in code itself... you can find it @ modules/Home/UnifiedSearchAdvanced.php

heta - the moment I thought of how (where) to achieve this I read your post.

Thanks!