From c6ac46adda42dfe023d1ba453d5534cdd17f583f Mon Sep 17 00:00:00 2001 From: yashodha Date: Tue, 17 Jan 2017 12:38:44 +0530 Subject: [PATCH] minor fix --- CRM/Activity/BAO/Query.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/CRM/Activity/BAO/Query.php b/CRM/Activity/BAO/Query.php index 042276c9c8..315ef64ff4 100644 --- a/CRM/Activity/BAO/Query.php +++ b/CRM/Activity/BAO/Query.php @@ -391,10 +391,10 @@ class CRM_Activity_BAO_Query { break; case 'activity_priority': - $from .= " $side JOIN civicrm_option_group option_group_activity_priority ON (option_group_activity_priority.name = 'priority')"; - $from .= " $side JOIN civicrm_option_value activity_priority ON (civicrm_activity.priority_id = activity_priority.value - AND option_group_activity_priority.id = activity_priority.option_group_id ) "; - break; + $from .= " $side JOIN civicrm_option_group option_group_activity_priority ON (option_group_activity_priority.name = 'priority')"; + $from .= " $side JOIN civicrm_option_value activity_priority ON (civicrm_activity.priority_id = activity_priority.value + AND option_group_activity_priority.id = activity_priority.option_group_id ) "; + break; case 'civicrm_activity_tag': $from .= " $side JOIN civicrm_entity_tag as civicrm_activity_tag ON ( civicrm_activity_tag.entity_table = 'civicrm_activity' AND civicrm_activity_tag.entity_id = civicrm_activity.id ) "; -- 2.25.1