At times we have clients asking for similar requirement, that they want to filter results by related module’s field. <\/p>\n\n\n\n
Lets take basic modules and achieve similar goal by coding. Here, one needs to have idea about creating basic MySQL query. <\/p>\n\n\n\n
We have Accounts and Contacts module in SugarCRM. Accounts has one-many relationship with Contacts. We will add Accounts module’s type field in Contacts search. <\/p>\n\n\n\n
Steps are as below,<\/p>\n\n\n\n
Step 1 :<\/strong> Create non-db field in Contacts module named as account_type_search. Write following code into custom\/Extensions\/modules\/Contacts\/Ext\/Vardefs\/<anyname>.php <\/p>\n\n\n\n Step 2 :<\/strong> Write following code into search field definition. Copy modules\/Contacts\/metadata\/SearchFields.php to custom\/modules\/Contacts\/metadata\/SearchFields.php if doesn’t exist and write following code into it. If it exists at custom\/modules\/Contacts\/metadata\/SearchFields.php then add following code<\/p>\n\n\n\n'account_type_search' => array (\n\t'db_field' =>\n\tarray (\n\t 0 => 'id',\n\t),\n\t'query_type' => 'format',\n\t'operator' => 'subquery',\n\t'subquery' => 'SELECT accounts_contacts.contact_id FROM accounts_contacts\n\t\t\t\t INNER JOIN accounts ON accounts.id = accounts_contacts.account_id AND accounts.deleted = 0\n\t\t\t\t WHERE accounts_contacts.deleted = 0 AND accounts.account_type IN ({0})',\n),<\/code><\/pre>\n\n\n\n