Skip to main content
Question
Jason Rodgers
IT Coordinator
Asked a question 8 months ago

Looking for a quick ad-hoc report to signify what items are using Rubric grading

Where am I?

In The eLearning Community powered by Open LMS you can ask and answer questions and share your experience with others!

Rubric grading the database is a bit messy. 

SELECT mdl_grading_areas.activemethod ,mdl_grading_definitions.name, mdl_grading_definitions.description, mdl_course.fullname FROM mdl_grading_areas
LEFT JOIN mdl_context ON mdl_grading_areas.contextid = mdl_context.id
LEFT JOIN mdl_course_modules ON mdl_context.instanceid = mdl_course_modules.id
LEFT JOIN mdl_grading_definitions ON mdl_grading_areas.id = mdl_grading_definitions.areaid
LEFT JOIN mdl_course ON mdl_course_modules.course = mdl_course.id

WHERE mdl_grading_areas.activemethod='rubric'