I'm trying to exchange data between two platforms - import gradebook data from Moodle. I, seems, cannot find where gradebook category marks are stored. Is there such table or are they calculated on the fly?
This query does not return categories and marks for them:
SELECT C.*, G.RawGrade, G.FinalGrade
FROM mdl_grade_categories C
INNER JOIN mdl_grade_items I ON I.CategoryID = C.ID
INNER JOIN mdl_grade_grades G ON G.ItemID = I.ID
WHERE C.CourseID = 777 AND G.Userid = 888
Thanks.