Dated_modified & address list

[GILSL]

Hi!!!

1.- I need to know who has deleted a record. Dated_modified field does not say that user was, because that field only indicates who was the last to edit the registry.

2 .- You can synchronize the address list of an Exchange server?. I can not perform this process.

Thanks

[salesagility]

You would need to create a custom report or run a sql query to discover who deleted a record. It's not complex, sugarcrm stores the id of the person who last modified the record, and sets a flag to "1" if a record is deleted.

[GILSL]

Correct, but I've been testing, and when elina a result, the record = 1 does not match the last user to modify the registry, but corresponds with the last user edit the post.

Referring to the Exchange, I can do anything?

Thaks

[salesagility]

the modified_user_id returns the id of the person who last modified the record - including a deletion

[GILSL]

I'm doing tests but who gets eliminated, only edit the post last

[salesagility]

The person who deleted the record is also the person who last modified it

[GILSL]

The person who deleted the record is also the person A who last modified it is person B

[salesagility]

The person who deleted the record is also the person who last modified it

So, in the record, the last_modified row will contain the ID of the person who deleted it

[GILSL]

The table leads, I have last_modified, but date_modified. It may be why we can not find it?

[kuske]

If you add e logic_hook before delete like this:

                 if($event=="before_delete"){
// ---------------------------------------------------------------------------------------------
// ---------------------------------------------------------------------------------------------
                   $db = & PearDatabase::getInstance();
                                   
                   global $current_user;
                   $taeter = $current_user->id;
                   $query = "INSERT INTO accounts_audit (id,parent_id,date_created,created_by,field_name,data_type,before_value_string,after_value_string) ".
                            "VALUES (uuid(),'$focus->id',now(),'$taeter','deleted','bool','0','1');";
                   $result = $db->query($query, true,"Error auditing accounts.deleted: ");

                } 
  

you will see who deleted the record in the audit table.