Cross module Search

[ramji123]

Hi,

I am using Sugar4.5.1f pro version.

In search, we can't search Cross Module?

My requirement is :

I am searching the subject field in case module, it will search only case module. but i need these field also search in Notes table.

Is it possible?

Ramji

[dlorenzetti]

Hi Ramji,

You can put the informations in modules/Cases/metadata/SearchFields.php and modify the array "$searchFields['Cases']" in name.

like that:

'name' => array( 'query_type'=>'default','db_field'=>array('cases.n ame', 'notes.name')),

and the ListView going to build the query like that:

WHERE cases.name like '<search>%' OR notes.name like '<search>&'

but you need to have a relationshp between cases and notes, else the query going to return empty because it don't find the table notes.


Cheers,