Unified_search with custom and standard field in the same module

[leowolff]

Hello, one of our client request that the search on the top right corner of sugar should search in 2 accounts fileds (name in the accounts table, and razaocsocial_c in accounts_cstm). How do I do it?

I didnt find the razaosocial_c field on any vardef to put the 'unified_search' => true, so I went to edit the unified_search_modules.php on cache/modules

The standard search its like this:

 $unified_search_modules = 
array (
  'Accounts' => 
  array (
    'table' => 'accounts',
    'fields' => 
    array (
      'name' => 
      array (
        'vname' => 'LBL_ACCOUNT_NAME',
        'type' => 'name',
      ),
     ),
  ), 
  

If I change to this:

 $unified_search_modules = array (
  'Accounts' => 
  array (
    'table' => 'accounts',
    'fields' => 
    array (
      'name' => 
      array (
        'vname' => 'LBL_ACCOUNT_NAME',
        'type' => 'name',
      ),
    ),
  ),
  'Accounts' => 
  array (
    'table' => 'accounts_cstm',
    'fields' => 
    array (
      'razaosocial_c' => 
      array (
        'vname' => 'LBL_ACCOUNT_NAME',
        'type' => 'name',
      ),
    ),
  ), 
  

It just search for the second field (razaosocial_c) and ignore the first search.

Any help plz?