Assignment

Below is a report I created for the Configurable Reports plugin that use to link to ungraded Assign module submissions within the course context. You need to be in the course that has ungraded Assign submissions to find ones to grade. Otherwise, I would remove the course context. Please share any questions. -Ben, BlueSky Online School, MN

---

SELECT 

u.firstname AS "First",

u.lastname AS "Last",

a.name AS "Assignment",

convert(FROM_UNIXTIME(asb.timemodified),datetime) as LastSubmission,

case when asb.timemodified > g.timemodified

then 'resubmitted'

else asb.status end AS "Status",

concat('<a target="_blank" href="%%WWWROOT%%/mod/assign/view.php?rownum=0&userid=',asb.userid,'&id=',cm.id,'&action=grade','">Grade</a>')  AS "GradeLink"

 

FROM prefix_course AS c

JOIN prefix_course_modules AS cm ON c.id = cm.course

JOIN prefix_enrol AS en ON c.id = en.courseid

JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id

JOIN prefix_grade_items gi ON c.id = gi.courseid

JOIN prefix_grade_grades AS g on gi.id = g.itemid

JOIN prefix_assign AS a ON c.id = a.course

JOIN prefix_assign_submission AS asb ON asb.assignment = a.id

JOIN prefix_user AS u ON u.id = asb.userid

WHERE c.id = '%%COURSEID%%'

AND ue.userid = u.id

AND cm.module = 1

AND cm.instance = a.id 

AND gi.itemmodule = 'assign'

AND gi.iteminstance = a.id

AND g.userid = u.id

AND (g.finalgrade is NULL or asb.timemodified > g.timemodified)

and asb.status <> 'new'

ORDER BY LastSubmission