From d34ff76d513d05710e64b4d2be7105fd38f5f469 Mon Sep 17 00:00:00 2001 From: thomas Date: Mon, 19 May 2014 12:08:17 +0200 Subject: [PATCH] Logging-ChangeLog-Lookup-Bugfix --- CRM/Logging/Differ.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Logging/Differ.php b/CRM/Logging/Differ.php index 9c27255dc2..adcd2511fa 100644 --- a/CRM/Logging/Differ.php +++ b/CRM/Logging/Differ.php @@ -76,7 +76,7 @@ class CRM_Logging_Differ { $contactIdClause = "AND id = %3"; break; case 'civicrm_note': - $contactIdClause = "AND ( entity_id = %3 AND entity_table = 'civicrm_contact' ) OR (entity_id IN (SELECT note.id FROM `{$this->db}`.log_civicrm_note note WHERE note.entity_id = %3 AND note.entity_table = 'civicrm_contact') AND entity_table = 'civicrm_note')"; + $contactIdClause = "AND (( entity_id = %3 AND entity_table = 'civicrm_contact' ) OR (entity_id IN (SELECT note.id FROM `{$this->db}`.log_civicrm_note note WHERE note.entity_id = %3 AND note.entity_table = 'civicrm_contact') AND entity_table = 'civicrm_note'))"; break; case 'civicrm_entity_tag': $contactIdClause = "AND entity_id = %3 AND entity_table = 'civicrm_contact'"; -- 2.25.1