From fb7396a1ff5eab06ef25b423687b51e73473d0b1 Mon Sep 17 00:00:00 2001
From: tjhunt <tjhunt>
Date: Tue, 29 Jul 2008 13:10:02 +0000
Subject: [PATCH] Manual grading report - change query to work on Postgres.

---
 mod/quiz/report/reportlib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/mod/quiz/report/reportlib.php b/mod/quiz/report/reportlib.php
index 3ffd28aad5..41b50f3ede 100644
--- a/mod/quiz/report/reportlib.php
+++ b/mod/quiz/report/reportlib.php
@@ -110,7 +110,7 @@ function quiz_get_total_qas_graded_and_ungraded($quiz, $questionids, $userids){
 
     $params = array_merge($params, $u_params, $q_params);
     $sql = "SELECT qs.question, COUNT(1) AS totalattempts,
-            SUM(qs.event IN (".QUESTION_EVENTS_GRADED.")) AS gradedattempts
+            SUM(CASE WHEN (qs.event IN (".QUESTION_EVENTS_GRADED.")) THEN 1 ELSE 0 END) AS gradedattempts
             FROM
             {quiz_attempts} qa,
             {question_sessions} qns,
-- 
2.39.5