Search bug - need ideas for a fix

[hobbes]

We have used Studio to add Lead Source Description as one of the query fields available under Leads' Advanced Search. However this has resulted in advanced searches never returning any matches. It appears this is caused by Sugar including a space in the LSD input field. Manually removing this space each time an advanced search is made results in the proper results being displayed. Anyone know of a fix for this?

We've just upgraded to 4.5.0h (build 1239) on linux with PHP5.2.0/MySQL5.0.32.

[hobbes]

Another issue with the upgrade is that people bcc'd in messages are not getting them. Any thoughts on a fix for this is also appreciated.

[kbrill]

We have used Studio to add Lead Source Description as one of the query fields available under Leads' Advanced Search. However this has resulted in advanced searches never returning any matches. It appears this is caused by Sugar including a space in the LSD input field. Manually removing this space each time an advanced search is made results in the proper results being displayed. Anyone know of a fix for this?

We've just upgraded to 4.5.0h (build 1239) on linux with PHP5.2.0/MySQL5.0.32.

You would have to edit your SearchForm.html file and remove the space from there.

[cHEK]

I am having the same problem. The description field is not searching properly. I looked over SearchForm.php and nothing jumped out at me.

Were is the SearchForm.html file located?

[hobbes]

Thanks kbrill. Shortly after my last post I noticed the space in the textarea tag and manually removed. Am guessing however that future changes via Studio will require this manual change each time...

cHEK - the file is in modules/Leads/.

[Subrat]

Hello everybody

i m having thye same problem , that i hv added 5 more options in the lead status (drop down). the options are available in (lead information) but in advance search form only the default options are available not the extra options. while i published the search form also at the same time when i publish the (edit view & detail view) . i think the problem with the search form of the lead module.. i m very much exited to know that , is there any other way to publish this search form of lead module..

Thanx
Subrat

[cHEK]

Ok I found a space in

title='{DESCRIPTION_HELP}'}>{DESCRIPTION} </textarea>

now:
title='{DESCRIPTION_HELP}'}>{DESCRIPTION}</textarea>

The search works however it only will capture the results that have the search description term as their first word.

So if I search for "I" and someone has "I like leads" it will find it. However a search for "like" would render nothing.

Ideas?

[cHEK]

It seems all my Search feilds have this bug. They will only retrieve a record if the search term is the first word in the string.

Is anyone else seeing this?

[cHEK]

I have been looking through files trying to find a potential error and still no success getting the search form to work properly. If anyone has some tips I would really appreciate it.

[Raven]

look in SearchFrom.php, the main idea of a Search it look in database string 'value%' , so if your word is in the between other two word the search will not find it, cause it needs to be '%value%' so it could search it right in a database.

we solved this problem by adding a new operator like and its value = '%value%', which searches in description. if need some example source PM me.