Can't search by account name

**gerald29** · 2008-10-08, 04:59 PM

hello all,
i have just imported over 4000 leads into sugar. When i go to the leads module though and try to do a search based on the account name, it comes back with nothing. even if i search by the exact name with the case the same, it still refuses to bring back any results. I can search by all other items though, just not account name. any ideas?

**Angel** · 2008-10-09, 01:35 AM

What happens if you edit the name of one of the accounts that you are unable to find via the search, just to commit the name manually versus what the import did, then try to search for that record?

Perhaps the import process included some trailing characters that you are unable to see on the screen.

**andopes** · 2008-10-09, 02:06 AM

Hi Gerald

If you click on Clear at the Search Form does the ListView return all the Cases entries?
If you search for another field does the ListView returns correctly?

If yes for both then you can edit the file include/ListView/ListViewData.php and add the line:

PHP Code:

 echo "<PRE>$main_query";

Just after the line:

PHP Code:

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by'];

Then go to Cases ListView and try to do a Search by account_name.
If the ListView return no data, just a query string, copy it and paste to the phpMyAdmin and execute it there.
Probably it will return an error, it will guide you to solve the error.

Let us know the query string and the error.

Cheers

**roblaus** · 2008-10-09, 04:19 AM

Also try a quick repair or rebuild indexes in admin/repair, maybe the index wasn't contructed correctly. You may also search for a string like %part of the name% in order to exclude hidden leading characters as Angel said.

**pkranz** · 2008-10-16, 07:08 PM

If you are using Sugar version 5.1.0-RC or 5.1.0a, account name search will fail if you have accounts setup that are children of a parent account, its also present in some earlier releases. This is due to bug# 23291 and bug# 25401 which keeps getting fixed and re-broken again from release to release for most of this year.