One-Many Relate field to Search

[madhrishi]

Hi,

I have one to many relationship between Contacts[primary] and a custom module[related module]... Now, i need to add a relate field for the custom module to Contact's search... A relate field for contact is readily available in the custom module... but relate field for custom module is not available....

How do i do this?

i.e, Just like "account_name" in contact search......i want "custom_module_name" in contact search...

Thank You.

[crmbalah]

HI
try to customize the contact module subpaneldefs.php

[madhrishi]

But how will that affect the search view??

What i want is, a relate field for the custom module in Contact's search ..... contacts and custom have one - many relationship....

[madhrishi]

Any one plss? I thought there could be a very simple solution for this

[andopes]

crmbalah, your suggestion sounds like a LOTERY!!

madhrishi, when creating a relationship one to many between Contacts and your Custom Module, a subpanel of Custom Module will be rendered into Contacts DetailView and the Contacts field will be rendered into Custom Module views.
So no Custom Module field is created by default on Contacts module, the way you need to create it by hand into extended vardefs of Contacts and render it into searchdefs.php.
You also will need to create a custom controller for Contacts to override the $this->bean as an instance of a new class which extends the default Contact class.
This new class should implements the method create_new_list_query to deal properly with the new Custom Module field when generating the sql query.

Let us know if you need further details.

Best regards

[madhrishi]

Thank You Andopes..

I was ok until

"You also will need to create a custom controller for Contacts to override the $this->bean as an instance of a new class which extends the default Contact class.
This new class should implements the method create_new_list_query to deal properly with the new Custom Module field when generating the sql query."

How do i do this? I have no coding knowledge

I thought of adding the custom relate field to contacts only because search by contacts in custom module field is not working...

You have previously answered this issue...here... do u think i am also facing the same issue??

http://www.sugarcrm.com/forums/showt...ght=any+search