vardefs relationships

[mano.f]

Hello everyone,

I just started working with sugar crm and noticed something funny with the relationships I created in studio. When I look in the filesystem at the file vardefs.ext.php, my relationship names get changed into a mess, here is an example


$dictionary["Dev_LinkPerson"]["fields"]["dev_partic5013cipant1_ida"] = array (
'name' => 'dev_partic5013cipant1_ida',
'type' => 'link',
'relationship' => 'dev_participant1_dev_linkperson',
'source' => 'non-db',
'reportable' => false,
'side' => 'right',
'vname' => 'LBL_DEV_PARTICIPANT1_DEV_LINKPERSON_FROM_DEV_LINK PERSON_TITLE',
);

When I try to reference the relationship I created 'dev_participant1_dev_linkperson', nothing happens and I have to use the relationship 'dev_partic5013cipant1_ida' instead.
Why is this?
I'm using 6.1 CE

[andopes]

Relationships created by Studio are built in an upgrade safe way, the way its foreign keys are stored in an extra table instead of core table.

So for your scenario, it seems you created an One to Many relationship between Participant and Person, so SugarCRM creates an extended vardefs for Person with the fields:

<relationship_field>_id: pseudo field to store related id
<relationship_field>_name: pseudo field to store related name
<relationship_field>: pseudo field to fetch a list of related records (dev_participant1_dev_linkperson)


And an extended vardefs for Participant with the field:
<relationship_field>: pseudo field to fetch a list of related records

Whenever you create a record from Person you can specify the Participant in 2 ways:

 $person->dev_partic5013cipant1_ida = 'some value'; 
  

This will make SugarCRM saves the Participant in the relationship table as soon as you save the $person.

 $person->save();
$person->load_relationship('dev_participant1_dev_linkperson');
$person->dev_participant1_dev_linkperson->add('some value'); 
  

This will automatically save the Participant id in relationship table.

Cheers