From 4a3c55d99b3d546d808975face13f61c2f1170cc Mon Sep 17 00:00:00 2001 From: Jon Goldberg Date: Thu, 21 Feb 2019 21:06:13 -0500 Subject: [PATCH] reporting#10 - fix pagination on Contribution Detail report --- CRM/Report/Form/Contribute/Detail.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/CRM/Report/Form/Contribute/Detail.php b/CRM/Report/Form/Contribute/Detail.php index 6365ccd8ef..10690896e7 100644 --- a/CRM/Report/Form/Contribute/Detail.php +++ b/CRM/Report/Form/Contribute/Detail.php @@ -472,9 +472,10 @@ GROUP BY {$this->_aliases['civicrm_contribution']}.currency"; * * @return string */ - public function buildQuery($applyLimit = TRUE) { + public function buildQuery($applyLimit = FALSE) { if ($this->isTempTableBuilt) { - return "SELECT * FROM civireport_contribution_detail_temp3 $this->_orderBy"; + $this->limit(); + return "SELECT SQL_CALC_FOUND_ROWS * FROM civireport_contribution_detail_temp3 $this->_orderBy $this->_limit"; } return parent::buildQuery($applyLimit); } @@ -509,7 +510,6 @@ GROUP BY {$this->_aliases['civicrm_contribution']}.currency"; // 1. use main contribution query to build temp table 1 $sql = $this->buildQuery(); $this->createTemporaryTable('civireport_contribution_detail_temp1', $sql); - $this->setPager(); // 2. customize main contribution query for soft credit, and build temp table 2 with soft credit contributions only $this->queryMode = 'SoftCredit'; -- 2.25.1