Building a new relationship with emails (e-mails)

[youssefaoun]

Hello,

I am trying to build a new relationship with the module e-mails.
The new module is Scontacts

The relationship file emails_scontactsMetaData.php contains the following:

 <?php
$dictionary['emails_scontacts'] = array (
    'table' => 'emails_scontacts',
    'fields' => array (
        array(
            'name' => 'id',
            'type' => 'varchar',
            'len'=>'36'
        ),
        array(
            'name' => 'email_id',
            'type' => 'varchar',
            'len' => '36',
        ),
        array(
            'name' => 'scontact_id',
            'type' => 'varchar',
            'len' => '36',
        ),
        array (
            'name' => 'date_modified',
            'type' => 'datetime'
        ),
        array(
            'name' => 'deleted',
            'type' => 'bool',
            'len' => '1',
            'default' => '0',
            'required' => true
        )
    ),
    'indices' => array (
        array(
            'name' => 'emails_scontactspk',
            'type' => 'primary',
            'fields' => array('id')
        ),
        array(
            'name' => 'idx_scon_ema_ema',
            'type' => 'index',
            'fields' => array('email_id')
        ),
        array(
            'name' => 'idx_scon_ema_eco',
            'type' => 'index',
            'fields' => array('scontact_id')
        ),
        array(
            'name' => 'idx_scontact_email',
            'type' => 'alternate_key',
            'fields' => array('email_id','scontact_id')
        )
    ),
    'relationships' => array (
        'emails_scontacts' => array(
            'lhs_module' => 'Emails',
            'lhs_table' => 'emails',
            'lhs_key' => 'id',
            'rhs_module' => 'Scontacts',
            'rhs_table' => 'scontacts',
            'rhs_key' => 'id',
            'relationship_type' => 'many-to-many',
            'join_table' => 'emails_scontacts',
            'join_key_lhs' => 'email_id',
            'join_key_rhs' => 'scontact_id'
        )
    ),
);
 
?>  

It is a copy of the "Example_module", in other words the Widgets module


I HAVE ABSOLUTELY NO RESULT. THE SAME THING WORKS WITH Contacts, Cases...etc

Any hints?

Regards,

[andopes]

Hi, youssefaoun.

Did you define the field emails into scontacts vardefs and the fields scontacts into emails vardefs?

This could be the reason.

Cheers

André Lopes
Lâmpada Global Services
Av. Angelica, 1814 cj. 1502
São Paulo, SP 01228-200
tel1. 55 11 3668-6776
tel2. 55 11 3822-2581
cel. 55 11 7636-5859
messenger: andopes@yahoo.com.br
skype: andopes
e-mail: andre@lampadacrm.com.br