From 77e4d022f03a583b356aad6a756bcdc7e4f2c12d Mon Sep 17 00:00:00 2001 From: Edsel Date: Mon, 11 May 2015 17:14:22 +0530 Subject: [PATCH] ICM-13 Modified LYBUNT report to use temp table instead of modifiication to query --- CRM/Report/Form/Contribute/Lybunt.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/CRM/Report/Form/Contribute/Lybunt.php b/CRM/Report/Form/Contribute/Lybunt.php index d73b9dc25e..7976103ef2 100644 --- a/CRM/Report/Form/Contribute/Lybunt.php +++ b/CRM/Report/Form/Contribute/Lybunt.php @@ -394,7 +394,8 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { AND {$this->_aliases['civicrm_line_item']}.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") GROUP BY {$this->_aliases['civicrm_contribution']}.id"; CRM_Core_DAO::executeQuery($sql); - $this->_from .= " INNER JOIN civicrm_contribution_temp temp ON {$this->_aliases['civicrm_contribution']}.id = temp.id "; + $this->_from .= " + INNER JOIN civicrm_contribution_temp temp ON {$this->_aliases['civicrm_contribution']}.id = temp.id "; } public function groupBy() { -- 2.25.1