From 5ce7a8550c1e29f86c1a3c8c421fb5b0de450bd8 Mon Sep 17 00:00:00 2001 From: Brian Shaughnessy Date: Tue, 21 Sep 2021 15:43:26 -0400 Subject: [PATCH] dev/core#2850 update_email_resetdate consider opt out on hold --- CRM/Mailing/Event/BAO/Delivered.php | 1 + 1 file changed, 1 insertion(+) diff --git a/CRM/Mailing/Event/BAO/Delivered.php b/CRM/Mailing/Event/BAO/Delivered.php index f14176652b..59410775d6 100644 --- a/CRM/Mailing/Event/BAO/Delivered.php +++ b/CRM/Mailing/Event/BAO/Delivered.php @@ -288,6 +288,7 @@ class CRM_Mailing_Event_BAO_Delivered extends CRM_Mailing_Event_DAO_Delivered { AND civicrm_mailing_job.status = 'Complete' AND civicrm_mailing_job.end_date BETWEEN DATE_SUB(NOW(), INTERVAL $maxDays day) AND DATE_SUB(NOW(), INTERVAL $minDays day) AND (civicrm_email.reset_date IS NULL OR civicrm_email.reset_date < civicrm_mailing_job.start_date) + AND civicrm_email.on_hold != 2 GROUP BY civicrm_email.id "; CRM_Core_DAO::executeQuery($query); -- 2.25.1