search for leads by a meetings

[yossidev]

Hi
I'm using sugarcrm community Version 6.2.2.
I'm trying to add a field in the advanced search of leads module, which will give me leads according to its related meetings.
for example:
I want to search for all the leads (in the search panel of the leads module) which have meetings with a 'Planned' status. (the field in the search panel should be a dropdown of the 'meeting status')

how can I do that?
thanks in advance for any help.

[rafael.q.g@hotmail.com]

I think you can define a field in your searchdefs.php, using as exemple the assigned user field, thsi will render you field correctly.

 'assigned_user_id' => 
                          array (
                            'name' => 'assigned_user_id',
                            'type' => 'enum',
                            'label' => 'LBL_ASSIGNED_TO',
                            'function' => 
                            array (
                              'name' => 'get_user_array',
                              'params' => 
                              array (
                                0 => false,
                              ),
                            ), 
  

Now to make it searchesworks you shoud customize your seachFields.php adding a new entry for your custom field with the desired sql select criteria.