Add a custom field (of contact module) in the search layout of meeting module

💬 General Discussion
1

Hi,

Is it possible to search a custom field of a contact within the meeting?

For example:

In meeting module and if the meeting is related to a contact, I want to be able to search the “contact_sale” which is a custom field of contacts module.

Unfortunately, I am not able to add that custom field in the search layout of meeting.

How shall I achieve this? Any idea please?

2

Hi I already managed to add he field however I am still having filtering issue.

I am only having issue with a custom field of contacts (not in a default field)

within SearchFields.php (custom folder) added this:

‘stage_c’ =>
array (
‘query_type’ => ‘default’,
‘db_field’ =>
array (
0 => ‘contacts_cstm.stage_c’,
),
),

and also added some code in vardefs (custom folder) :
$dictionary[“Meeting”][“fields”][“stage_c”]= array(
‘name’ => ‘stage_c’,
‘vname’ => ‘LBL_STAGE_C’,
‘query_type’ => ‘default’,
‘source’ => ‘non-db’,
‘type’ => ‘enum’,
‘options’ => ‘stage_c_list’,
‘studio’ => array(‘searchview’=>true,‘visible’=>false),
);

error: Unknown column ‘contacts_cstm.stage_c’ in ‘where clause’

if the field is derived from a cstm table, it doesn’t seem to work.

Any idea please?

3

Hi,

any idea please?

4

Check this out…

https://developer.sugarcrm.com/2011/02/08/customize-search-fields-and-add-new-ones-in-sugarcrm/