SuiteCRM
SuiteCRM copied to clipboard
Deleting a Target List doesn't update the date_modified of its relationship records
Issue
If we have a Target List with several related records (Contacts, Leads, Accounts), these relationships are defined in the DB table "prospect_lists_prospects". If we delete that Target Lists, those relationship records are set with "deleted =1" but the date_modified isn't updated.
Expected Behavior
The date_modified of a related relatioship record of a Target List isn't updated when the Target List is deleted.
Actual Behavior
The date_modified isn't updated, that can be confusing
Possible Fix
https://github.com/SalesAgility/SuiteCRM/blob/master/modules/ProspectLists/ProspectList.php#L429-L430Update the date_modified here.
Steps to Reproduce
- Create a Target List
- Add Contact records
- Delete Target Lists
- Check in the DB that the date_modified of the table "prospect_lists_prospects" of those records hasn't been updated
Context
This can be problematic if you are observing that date field
Your Environment
SuiteCRM Version used: Version 7.12.6 Browser name and version: Versión 100.0.4896.88 (Build oficial) (64 bit Environment name and version: MySQL, PHP 7 Operating System and version: Ubuntu 20.04