Custom Module with SecuritySuite

[thinkwelldesigns]

I'm about to get driven up a wall here. I've created a custom module and I want to control the records in the same way that I'm controlling the Contacts records - Group Members can only view contacts assigned to them. With Contacts records, all works well. With my custom module, it doesn't.

Here is a screenshot of my relationships.


Original sap_applianceslist_securitygroupsMetaData.php code:

 <?php
// created: 2010-04-19 14:59:58
$dictionary["sap_applianceslist_securitygroups"] = array (
  'true_relationship_type' => 'many-to-many',
  'relationships' => 
  array (
    'sap_applianceslist_securitygroups' => 
    array (
      'lhs_module' => 'SAP_AppliancesList',
      'lhs_table' => 'sap_applianceslist',
      'lhs_key' => 'id',
      'rhs_module' => 'SecurityGroups',
      'rhs_table' => 'securitygroups',
      'rhs_key' => 'id',
      'relationship_type' => 'many-to-many',
      'join_table' => 'sap_appliancuritygroups_c',
      'join_key_lhs' => 'sap_applia22daceslist_ida',
      'join_key_rhs' => 'sap_applia72f8ygroups_idb',
    ),
  ),
  'table' => 'sap_appliancuritygroups_c',
  'fields' => 
  array (
    0 => 
    array (
      'name' => 'id',
      'type' => 'varchar',
      'len' => 36,
    ),
    1 => 
    array (
      'name' => 'date_modified',
      'type' => 'datetime',
    ),
    2 => 
    array (
      'name' => 'deleted',
      'type' => 'bool',
      'len' => '1',
      'default' => '0',
      'required' => true,
    ),
    3 => 
    array (
      'name' => 'sap_applia22daceslist_ida',
      'type' => 'varchar',
      'len' => 36,
    ),
    4 => 
    array (
      'name' => 'sap_applia72f8ygroups_idb',
      'type' => 'varchar',
      'len' => 36,
    ),
  ),
  'indices' => 
  array (
    0 => 
    array (
      'name' => 'sap_appliansecuritygroupsspk',
      'type' => 'primary',
      'fields' => 
      array (
        0 => 'id',
      ),
    ),
    1 => 
    array (
      'name' => 'sap_appliansecuritygroups_alt',
      'type' => 'alternate_key',
      'fields' => 
      array (
        0 => 'sap_applia22daceslist_ida',
        1 => 'sap_applia72f8ygroups_idb',
      ),
    ),
  ),
);
?>  

New sap_applianceslist_securitygroupsMetaData.php code as specified in the manual.

 <?php
$dictionary["sap_applianceslist_securitygroups"] = array (
'true_relationship_type' => 'many-to-many',
'relationships' =>
array (
    ' sap_applianceslist _securitygroups' =>
    array (
    'lhs_module' => 'SecurityGroups',
    'lhs_table' => 'securitygroups',
    'lhs_key' => 'id',
    'rhs_module' => 'SAP_AppliancesList',
    'rhs_table' => 'sap_applianceslist',
    'rhs_key' => 'id',
    'join_table' => 'securitygroups_records',
    'join_key_lhs' => 'securitygroup_id',
    'join_key_rhs' => 'record_id',
    'relationship_type' => 'many-to-many',
    'relationship_role_column' => 'module',
    'relationship_role_column_value' => ' SAP_AppliancesList',
    ),
),
);
?>  

I then rebuild the relationships, but still I don't see the AppliancesList according to Group. Nothing shows on the list at all. I've restored the original code and tried painstakingly to recreate the file properly, several times.

What can I do?

[eggsurplus]

What version of Sugar are you on? If you follow the manual it should work. I'll verify on your version that it does.

[thinkwelldesigns]

What version of Sugar are you on? If you follow the manual it should work. I'll verify on your version that it does.

I'm using 5.5.1 CE, and I'm very much trying to follow the manual.

[eggsurplus]

I'll try it on 5.5.1. It may be that there was a significant change in 5.5.1 that was not caught for getting custom module support working.

[thinkwelldesigns]

Much appreciated. I've been trying it additionally by creating very small dummy modules, and I'm not having success there either on the dummies.

It's working jim-dandy on the standard modules such as contacts or cases, however, with all else being equal regarding users/roles/security groups.

[eggsurplus]

Found it. For some reason copying and pasting directly from the PDF causes a bunch of spaces. There are three added spaces throughout the version you have. Here's a correct version:

 <?php
$dictionary["sap_applianceslist_securitygroups"] = array (
'true_relationship_type' => 'many-to-many',
'relationships' =>
array (
    'sap_applianceslist_securitygroups' =>
    array (
    'lhs_module' => 'SecurityGroups',
    'lhs_table' => 'securitygroups',
    'lhs_key' => 'id',
    'rhs_module' => 'SAP_AppliancesList',
    'rhs_table' => 'sap_applianceslist',
    'rhs_key' => 'id',
    'join_table' => 'securitygroups_records',
    'join_key_lhs' => 'securitygroup_id',
    'join_key_rhs' => 'record_id',
    'relationship_type' => 'many-to-many',
    'relationship_role_column' => 'module',
    'relationship_role_column_value' => 'SAP_AppliancesList',
    ),
),
);
?>  

[thinkwelldesigns]

So the solution, once found, really was simple...

Thank you so much. That works perfectly on two modules I've tried. Thanks so much for an excellent module.

[eggsurplus]

Not a problem. While digging into this issue though I did run into an issue with inheritance and with shortcuts disappearing for custom modules in 5.5.1. I'll have a fix out shortly that can be downloaded.

[RLJB]

Hi

I have installed SecruitySuite. I turned on "Non Inheritable" and the shortcuts have disappeared? Even when I turn off "Non Inheritable" the shortcuts are still not there?

Can you advise how to fix?

Version is 5.5.0

Thanks

R.

UPDATE: Sorry I found the solution on the Sugarforge forum here: http://www.sugarforge.org/forum/foru...&forum_id=2544