SuiteCRM icon indicating copy to clipboard operation
SuiteCRM copied to clipboard

Deleting a Target List doesn't update the date_modified of its relationship records

Open SinergiaCRM opened this issue 2 years ago • 0 comments

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-L430

Update the date_modified here.

Steps to Reproduce

  1. Create a Target List
  2. Add Contact records
  3. Delete Target Lists
  4. 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

SinergiaCRM avatar Aug 01 '22 14:08 SinergiaCRM