I am using SugarCrm CE 6.5.20, Out the box it does not allow searching from related modules with a many to many relationship. But this can be overcome by adding a custom relate field that respresents your relationship then using a custom subquery in SearchFields.php like so :
'par_med_cond' =>Anybody know how to get this working with the popup view Im at a loss here.
'query_type' => 'default',
'operator' => 'subquery',
'subquery' => 'SELECT spsmc.frp_fundraisingprogram_contacts_1contacts_idb FROM frp_fundraisingprogram_contacts_1_c spsmc LEFT JOIN frp_fundraisingprogram smc ON spsmc.frp_fundraisingprogram_contacts_1frp_fundraisingprogram_ida = smc.id WHERE smc.deleted =0 AND spsmc.deleted =0 AND smc.name LIKE',
0 => 'id',
This works on a normal listview advanced search panel but does not work when adding the field to popupview search.