audit account name in contact module

[kajanni]

Hi
i'm using sugarcrm ce 5.1.0b Build 4905.
I want to audit the accountname field in the contact module.
I tried the following even its for 4.5.1
https://www.sugarcrm.com/forums/showthread.php?p=129689

But it didnt work. I also looked at 5.2. but it isn't a feature there either.
If anyone has a soluton i wolud like to here it.
thx
jan

[kuske]

The referenced patch works in 5.1.0a-5.1.0c and in 5.2.0.

Do not forget to set the

'audited'=>'true',

lines in vardef.php like:

  'account_name' =>
  array (
   'name' => 'account_name',
   'rname' => 'name',
   'id_name' => 'account_id',
   'vname' => 'LBL_ACCOUNT_NAME',
   'join_name'=>'accounts',
   'type' => 'relate',
   'link' => 'accounts',
   'table' => 'accounts',
   'isnull' => 'true',
   'module' => 'Accounts',
   'dbType' => 'varchar',
         'audited'=>'true',
   'len' => '255',
   'source' => 'non-db',
   'unified_search' => true,
  ),
 'account_id' =>
  array (
   'name' => 'account_id',
   'rname' => 'id',
   'id_name' => 'account_id',
   'vname' => 'LBL_ACCOUNT_ID',
   'type' => 'relate',
   'table' => 'accounts',
   'isnull' => 'true',
   'module' => 'Accounts',
   'dbType' => 'id',
         'audited'=>'true',
   'reportable'=>false,
   'source' => 'non-db',
   'massupdate' => false,
            'duplicate_merge'=> 'disabled',
            'hideacl'=>true,
  ), 
  

[kajanni]

hm ok and the vardef.php should be in sugar/modules/Contacts/vardef.php am i right?

and the other patch should be in sugar/includes/database/DBHelper.php am i right?

i will try this again
thx

[kajanni]

yes it works.
thanks a lot. now the account id is in the change log, but not the account name. Any idea?
I mean i'm happy like this but i'd like to understand this.
but thx a lot

[kuske]

If you mark account_id and account_name in vardefs.php with audited = true, you should see ...

... in the database a a line containing the changed account_id

... in the panel "View change log" the changed account_name

This is because of the special handling for related fields in panels.