Re: Search is very weak...
For partial matches, you don't need a % at the end. %value is the same as %value%.
For your global search, have you looked through your sugarcrm.log for any errors that occur during the search (or any other logs for that matter)? Its obviously not working correctly, and usually those are good places to start to find errors.
And, unfortunately, Sugar already goes through a lot of processing when it does its searches, so functionality like 'Steve' for 'Stephen' is probably not going to be implemented unless you do it yourself. SugarCorp is working on improving the search (they added ranged searches for integer and date fields in 6.2) but it still isn't the best. They do well though; when you look at all the modules and all the information the system is supposed to hold, sometimes you have to cut your losses in favor of faster processing.
Robert Beckman
Software Engineer
Mirth Corporation
Bookmarks