From 9c3d8af4540afcc728fb7f0720f94ddd94b2f2a8 Mon Sep 17 00:00:00 2001 From: monishdeb Date: Tue, 26 Nov 2013 15:23:48 +0530 Subject: [PATCH] CRM-13738 related fix on 'Limit current user' filter handling on Where clause ---------------------------------------- * CRM-13738: Activity Report fails if filtering on any contact http://issues.civicrm.org/jira/browse/CRM-13738 --- CRM/Report/Form/Activity.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Report/Form/Activity.php b/CRM/Report/Form/Activity.php index 863fbad652..1d42d0b158 100644 --- a/CRM/Report/Form/Activity.php +++ b/CRM/Report/Form/Activity.php @@ -480,7 +480,7 @@ class CRM_Report_Form_Activity extends CRM_Report_Form { // get current user $session = CRM_Core_Session::singleton(); if ($contactID = $session->get('userID')) { - $clause = "( civicrm_contact_source.id = " . $contactID . " OR civicrm_contact_assignee.id = " . $contactID . " OR civicrm_contact_target.id = " . $contactID . " )"; + $clause = "civicrm_contact_{$recordType}.id = " . $contactID; } else { $clause = NULL; -- 2.25.1