AnsweredAssumed Answered

Make a field usable in Reports that was added in a relationship?

Question asked by EdLeger on Jan 21, 2015
Latest reply on Jan 23, 2015 by EdLeger
Hi !
I have a many-to-many relation ship for module Accounts (accounts_accounts_1_c relationship).
In this relationship I added a field (name_rel).
I edited the custom/Extension/modules/Accounts/Ext/Vardefs/accounts_accounts_1_Accounts.php file adding this :
$dictionary["Account"]["fields"]["accounts_accounts_1name_rel"] = array(
    'name' => "accounts_accounts_1name_rel",
    'type' => 'varchar',
    'source' => 'non-db',
    'vname' => 'LBL_ACCOUNT_NAME_REL',
    'massupdate' => false,
    'reportable' => true,
  );
So I have my field in the database and I filled the values 'manually' (not through Sugar's interface). And now I have relationships like this :
Account A <= "REL1" => Account B
Account A <= "REL2" => Account B
Account C <= "REL1" => Account B
Account A <= "REL2" => Account D


Now what I would need is using these informations in the Reports module (and after using these reports for mailing). I added the 'reportable' => true definition but it didn't do anything.
Any ideas ?

Outcomes