Opportunities not 'global search'able anymore ...

[icedieler]

Somehow my Opportunities module (renamed to "Beratung", which should be no problem) is not indexed by the global search anymore, although the Opportunities module is included in the global search as standard.

I have tried to deselect and reselect the module on the result page and did another search, but without any luck. The module is activated for global search by default.

I have checked the following pages:

http://www.sugarcrm.com/forums/showthread.php?t=15563
http://www.sugarcrm.com/forums/showthread.php?t=20777
http://developers.sugarcrm.com/wordp...global-search/
http://www.sugarcrm.com/forums/showthread.php?t=46729

But most of them don't address my problem directly since I'm trying to re-enable search for a standard module (which I didn't even disable by myself). I don't want to include a custom module in the global search.

Normal and advanced searches work perfectly.

The first lines of my vardefs.php of the Opportunity module look like this (which should be pretty standard for a SugarCRM 6.1x version):

$dictionary['Opportunity'] = array('table' => 'opportunities','audited'=>true, 'unified_search' => true,'duplicate_merge'=>true,
		'comment' => 'An opportunity is the target of selling activities',
		'fields' => array (
  'name' =>
  array (
    'name' => 'name',
    'vname' => 'LBL_OPPORTUNITY_NAME',
    'type' => 'name',
    'dbType' => 'varchar',
    'len' => '50',
    'unified_search' => true,
    'comment' => 'Name of the opportunity',
    'merge_filter' => 'selected',
    'importable' => 'required',
    'required' => true,
  ),
  'opportunity_type' =>
  array (
    'name' => 'opportunity_type',
    'vname' => 'LBL_TYPE',
    'type' => 'enum',
    'options'=> 'opportunity_type_dom',
    'len' => '255',
    'audited'=>true,
    'comment' => 'Type of opportunity (ex: Existing, New)',
    'merge_filter' => 'enabled',
  ),

So the module IS activated for the global search function ... but searches don't deliver any results.

I know that I don't deliver much information, but maybe someone has experienced a similar problem and found a solution.

Thank you in advance!

[icedieler]

Problem found and solved. In case anybody else has the same problem:

The file module/Opportunities/vardefs.php declared a field to include in teh global search which did not exist inside the database table (account_name). It wasn't needed to be included in the global search anyway, so it was removed:

 $dictionary['Opportunity'] = array('table' => 'opportunities','audited'=>true, 'unified_search' => true,'duplicate_merge'=>true,
        'comment' => 'An opportunity is the target of selling activities',
        'fields' => array (
  'name' =>
  array (
    'name' => 'name',
    'vname' => 'LBL_OPPORTUNITY_NAME',
    'type' => 'name',
    'dbType' => 'varchar',
    'len' => '50',
    'unified_search' => true,
    'comment' => 'Name of the opportunity',
    'merge_filter' => 'selected',
    'importable' => 'required',
    'required' => true,
  ),
  'opportunity_type' =>
  array (
    'name' => 'opportunity_type',
    'vname' => 'LBL_TYPE',
    'type' => 'enum',
    'options'=> 'opportunity_type_dom',
    'len' => '255',
    'audited'=>true,
    'comment' => 'Type of opportunity (ex: Existing, New)',
    'merge_filter' => 'enabled',
  ),
/*  'account_name' =>
  array (
    'name' => 'account_name',
    'rname' => 'name',
    'id_name' => 'account_id',
    'vname' => 'LBL_ACCOUNT_NAME',
    'type' => 'relate',
    'table' => 'accounts',
    'join_name'=>'accounts',
    'isnull' => 'true',
    'module' => 'Accounts',
    'dbType' => 'varchar',
    'link'=>'accounts',
    'len' => '255',
        'source'=>'non-db',
        'unified_search' => true,
        'required' => true,
        'importable' => 'required',
     'required' => true,
  ),*/