Record deletion clean Emails

Hello, like this !560 (merged) Recycle must delete related Emails stored in vtiger_crmentity and vtiger_activity.

@manuelgit Can you please update us with case scenario, when you are looking for Cleaning up Email records?

Hello @uma.s Sure.

Imagine a contact record where have been sent emails to him and they got related to.

For any reason, contact asked his information to be deleted.

Now, if you delete that contact, emails still in database and still see emails in history home dashboard (not protecting customer email etc)

Note: Relation table between crmid and activityid - vtiger_seactivityrel

@manuelgit Thanks! for the test-case. I will analyze and get back to you.

mentioned in merge request !592 (merged)

Status changed to closed by commit be13dffc

@uma.s thanks for this commit:

Just found this

error found "an alias was previously found near relationdata"

Status changed to reopened

@manuelgit Can you please be precise on the test-case, As i can see the activites and comments records related to record are deleted successfully.

@uma.s Hello, doesn't delete emails as they still in database in vtiger_activity table

@uma.s also comments are deleted only if execute individual delete from recycle bin. If you execute recycle bin "bulk empty" comments are not deleted.

Will investigate better as i cannot test in demo instance vtiger recycle bin

https://demo.vtiger.com/vtigercrm/index.php?module=RecycleBin&view=List&app=TOOLS

Status changed to closed

@manuelgit I have re-checked this with both individual delete and mass empty of recycle bin, which works fine. Please do re-check on the lastest installation of current master source.

@uma.s thanks, you are right, i was talking about the button "Empty Recycle Bin" in vt 6.5

Milestone changed to 7.3

Added enhancement label