From 1ad2f4125330ed3fe1da11617fe3152dec64e89a Mon Sep 17 00:00:00 2001 From: toyomoyo Date: Wed, 18 Jul 2007 06:21:55 +0000 Subject: [PATCH] negative grades might be used so use null check instead. might break other db so might need a sql_null() function or something similar --- grade/report/grader/lib.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/grade/report/grader/lib.php b/grade/report/grader/lib.php index 4ece4997c7..41f836d751 100644 --- a/grade/report/grader/lib.php +++ b/grade/report/grader/lib.php @@ -771,7 +771,7 @@ class grade_report_grader extends grade_report { $this->groupwheresql AND ra.roleid in ($this->gradebookroles) AND ra.contextid ".get_related_contexts_string($this->context)." - AND g.finalgrade >= 0 + AND NOT g.finalgradeIS NULL GROUP BY g.itemid"; $groupsum = array(); @@ -858,7 +858,7 @@ class grade_report_grader extends grade_report { WHERE gi.courseid = $this->courseid AND ra.roleid in ($this->gradebookroles) AND ra.contextid ".get_related_contexts_string($this->context)." - AND g.finalgrade >= 0 + AND NOT g.finalgrade IS NULL GROUP BY g.itemid"; $classsum = array(); -- 2.39.5