History Subpanel | How to show the related module's History Subpanel data

[farhanbuhari2000]

@suitecrm_developer
pls help me
How to show the related module’s History Subpanel data .

In Contact module record - history subpanel has 1 record

opportunity module record is related with this contact
i need to show contact module’s history Subpanel record here in Opportunity’s history subpanel without using DB

[crmspace]

Hey,
recent similar thread:

Relate Activities (Calls/Meetings/Tasks/Notes) to both Accounts & Opportunities

Hi Team, @pgr @diligent I would need to relate Activities to Account & Opportunity simultaneously. ATM If we relate any Activity to Opportunity , we were not able to relate it to Account simultaneously. Can you please help me on how to achieve this? Thanks in advance for your help Regards, Sravani

[farhanbuhari2000]

i can not understand your idea .
can you please explain with details and files…

[suitecrm_developer]

1: You can use a Logic Hook for Contacts module.
After relationship add and after relationship delete for all history modules like notes, Tasks etc.
When a new record is associated with contact, you can also associate it with the opportunity. And this record will start showing up under opportunities detail page.
It may not happen automatically, yet you can do it by some custom code.
Help Links:

Logic Hooks

2: Or you can create your own custom subpanel in Opportunities module. And in there you can do the query to get all the related contacts history items. (I suggest this solution) as it is more performance efficient. No duplicate records in relationship tables will be added.
Help Links:

Creating custom subpanel on Users module

SQL errors are usually more explicit than that, they tell you exactly what is wrong… Try printing your $query variable to check if the quotes and variable substitution are working as intended.

Add custom subpanel in Accounts module