Unified search for account_name

[mapu]

It appears that the unified search (the Search box in the upper right) does not search on account name. Here is our issue:

1) We have a lead whose status is "In process".

2) The Account name is "MyCompany"

3) A search in the unified search box fails to find the lead

4) A search on a contact within that lead successfully provides results

Any help would be greatly appreciated.

Michael

[dpatech]

This looks like something that was broken during the 5.0 release. In 4.5.1 you could search on Leads.account_name using the unified search.

Here are the vardefs.php for Leads.account_name in version 4.5.1

   'account_name' => 
  array (
    'name' => 'account_name',
    'vname' => 'LBL_ACCOUNT_NAME',
    'type' => 'varchar',
    'len' => '150',
    'unified_search' => true, 
    'comment' => 'Account name for lead'
  ), 
  

In Sugar 5.0, this has been changed to a "Relate" field which does not make sense to me.

 'account_name' =>
array (
    'name' => 'account_name',
    'rname' => 'name',
    'id_name' => 'account_id',
    'vname' => 'LBL_ACCOUNT_NAME',
    'join_name'=>'accounts',
    'type' => 'relate',
    'link' => 'accounts',
    'table' => 'accounts',
    'isnull' => 'true',
    'module' => 'Accounts',
    'dbType' => 'varchar',
    'len' => '255',
), 
  

I think you could revert the definition for account_name back to what was used 4.5.1 and it would work ok. Sugar 5.0 still stores the value for account_name as a data field in the Leads table so what has been done makes no sense. If you try this be sure to use the "Admin" -> Repair tools to clear the vardefs cache. You may also have to delete the file "cache/modules/unified_search_modules.php" so Sugar will rebuild his list of unified_search_fields.

[Angelo]

Great tip it works.

I have cleared the cache from the admin panel.

Thanks !