I have two modules, consider A & B. In between them, there is many-to-many relationship. Now, there is another module, consider C. There is One-to-Many between A & C and B & C. Now while on editview of C module, both relate fields of module A & module B are present.
Now, after selecting any record from module A, while selecting records from module B, I want to show only those records which are related to the selected record of module A.
Now, I have came across these links, where they provided solution in the scenario of having One-to-Many relationship between these modules.
How can I customize the popup search to display possibilities depending on the parent page?
SugarCRM: relate field passing default values to pop-up select form
Wherein "One-to-Many" scenario, we can achieve the same by adding following code to editviewdefs.php file of targeted module, like this:
'displayParams' => array(
'initial_filter' => '&contact_name_advanced="+encodeURIComponent(document.getElementById("contact_name").value)+"',
),
OR like this:
'displayParams' => array (
'initial_filter' => '&account_name={$fields.account_name.value}',
),
But neither these posts mentioned any solution for "Many-to-Many" scenario nor I found any such post.
I came across another post:
SugarCRM Custom Query in popup list
where it suggested, along with above solution, to add few lines of code in popdefs.php file. But it is not wise option, as this popdefs.php file automatically generates by SugarCRM.
I came across few more posts:
How to Override view.popup in sugar CE 6.5.18
How I can customize query in view.popup in SugarCRM
where it suggested to customize the sql queries inside the popupview (view.popup.php) in SugarCRM. I tried that, but still I found no success. Kindly help. Thanks.