From 66aee2c2018a4a7930f4d24a192724137502ffdd Mon Sep 17 00:00:00 2001 From: Marina Glancy Date: Tue, 2 Sep 2014 09:39:57 +0800 Subject: [PATCH] MDL-47052 report_participation: fixed bug when filtering by first letter --- report/participation/index.php | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/report/participation/index.php b/report/participation/index.php index 7379f7ef0d5..4eeb959af6f 100644 --- a/report/participation/index.php +++ b/report/participation/index.php @@ -206,6 +206,7 @@ if (!empty($instanceid) && !empty($roleid)) { list($twhere, $tparams) = $table->get_sql_where(); if ($twhere) { + $params = array_merge($params, $tparams); $matchcount = $DB->count_records_sql($countsql.' AND '.$twhere, $params); } else { $matchcount = $totalcount; @@ -250,7 +251,6 @@ if (!empty($instanceid) && !empty($roleid)) { " GROUP BY userid) l ON (l.userid = ra.userid)"; if ($twhere) { $sql .= ' WHERE '.$twhere; // Initial bar. - $params = array_merge($params, $tparams); } if ($table->get_sql_sort()) { @@ -283,7 +283,6 @@ if (!empty($instanceid) && !empty($roleid)) { if ($twhere) { $sql .= ' WHERE '.$twhere; // Initial bar. - $params = array_merge($params, $tparams); } if ($table->get_sql_sort()) { -- 2.43.0