I want this kind of reports to be shown.
My achievement so far with below query is missing Result column whcih can be brought in by letters.. but not getting the context and its relation.
Module Course Grades Username
Quiz1 CF101 3.33000 student
Quiz1 CF101 8.89000 learner
Quiz1 CF101 3.33000 user1
Select mdl_grade_items.itemname,
mdl_course.shortname,
mdl_grade_grades.finalgrade,
mdl_user.username
From mdl_context Context Inner Join
mdl_grade_letters On Context.id = mdl_grade_letters.contextid,
mdl_course Inner Join
mdl_grade_items On mdl_grade_items.courseid = mdl_course.id Inner Join
mdl_grade_grades On mdl_grade_grades.itemid = mdl_grade_items.id Inner Join
mdl_user On mdl_user.id = mdl_grade_grades.userid
Group By mdl_grade_items.itemname,
mdl_course.shortname,
mdl_grade_grades.itemid,
mdl_grade_grades.userid,
mdl_user.id,
mdl_user.username,
mdl_grade_items.courseid,
mdl_grade_items.itemtype,
mdl_grade_items.itemmodule
Having mdl_grade_items.itemname Is Not Null And mdl_grade_grades.finalgrade Is
Not Null And mdl_grade_items.itemtype Is Not Null
Please guide me..
Gradebook
Getting a simple report externally from database
This discussion has been locked so you can no longer reply to it.