Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.
#2986 - Getting record details from both sides of a one-to-many relationship of the same module
We found that when a relationship within the same module is set up, normally doing it from studio, the user can only access to the details of one of the ends of the relationship, more specially the "many" end relationship.
For example, we have a one-to-many relationship between Contacts-Contacts:
[In this example we have two relationships, but it would be the same with 1]
If we go to the Mail Merge Reports option for selecting variables, we can see that this relationship appears in the subpanels section, as the "many" end of the relationship:
Then, if we go to the "relate" section, the "one" end of the relationship doesn't appear:
AND if we try to call it directly from the template relationship@@.... still doesn't work.
However, trying the native relationship "reports_to" that exists in SuiteCRM-SugarCRM between Contacts-Contacts appears in both ends.
Looking for the differences of the "reports_to" relationship and the custom relationship that we made, we saw that this can be solved adding a definition in the vardef. For example:
$dictionary["Contact"]["fields"]["contacts_contacts_1_one"] = array (
'name' => 'contacts_contacts_1_one',
'type' => 'link',
'relationship' => 'contacts_contacts_1',
'link_type' => 'one',
'source' => 'non-db',
'vname' => 'LBL_CONTACTS_CONTACTS_1_FROM_CONTACTS_L_TITLE',
'id_name' => 'contacts_contacts_1contacts_ida',
We think that there might be a conflict within the name of the relationship fields for each of the ends.
The solution stated above could work as a temporary patch, but it requires a code-intervention from a developer. Do you think another permanent solution can be found to solve this?
Thanks a lot,
Other add-ons of interest
Analytic Reporting Tool Basic
Dynamic Reports and Interactive Charts.
Powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is for anyone, no need for technical knowledge or SQL. Comes with over a hundred prebuilt reports.
Configure specific fields from specific modules and set formats like character limit, numeric, or alphanumeric and more for certain fields using Format Builder.
To view an uploaded document in SuiteCRM, the user has to download the document from SuiteCRM to the local machine and then the user has to open the document using an application. If the application to view the document is not available, the user has to find and Install it. We ease this process by i...