I have number of students who i have manually enrolled and also manually graded their results on the quiz. Their grades are showing on the grader report. but when create a configurable report to show these learners marks, they dont appear on the report. Am I doing something wrong?
Here is my configurable report code:
SELECT q.id,q.name,c.fullname as course_name,u.username, u.firstname, u.lastname as Surname,u.institution as Role,u.msn as Unit,u.yahoo as Region,FROM_UNIXTIME(ue.timecreated, '%Y-%m-%d') AS date_of_enrolement,DATE_FORMAT( FROM_UNIXTIME( qg.timemodified ) ,'%Y-%m-%d') AS Date_Completed,round(qg. grade,0) As Final_Grade
FROM prefix_user u
JOIN prefix_user_enrolments ue ON ue.userid = u.id
JOIN prefix_enrol AS en ON en.id = ue.enrolid
JOIN prefix_course AS c ON c.id = en.courseid
JOIn prefix_quiz as q ON q.course = c.id
JOIN prefix_quiz_grades qg ON qg.quiz = q.id and qg.userid = u.id
WHERE c.id = 1494
order by u.lastname ASC