General developer forum

this is the query for ungraded submissions for new MOODLE

SELECT   c.category AS ClassRoom
          , c.id AS CourseID 
          , a.id AS AssignmentID
          , asb.id AS SubmissiontID
          , u.id AS UserID
          , c.fullname AS Course
          , a.name AS Assignment
          , CONCAT('', a.name, '') AS Assignmentlink
          , CONCAT(u.firstname, ' ', u.lastname) AS UserName
          , ag.grade AS Grade
          , gi.grademax AS GradeMax
          , FROM_UNIXTIME(asb.timemodified) AS timemodified
     FROM mdl_assign_submission asb
     JOIN mdl_assign              a ON a.id = asb.assignment 
     LEFT JOIN mdl_assign_grades      ag ON ag.assignment = a.id 
                                    AND asb.assignment = ag.assignment 
                                    AND asb.userid = ag.userid
                                    AND asb.attemptnumber = ag.attemptnumber
     JOIN mdl_user                u ON u.id = asb.userid AND u.deleted = 0
     JOIN mdl_course              c ON c.id = 32 AND c.id = a.course
     JOIN mdl_modules            mo ON mo.name = 'assign'
     JOIN mdl_course_modules     cm ON a.course = cm.course AND cm.instance = a.id AND cm.module = mo.id
     JOIN mdl_grade_items        gi ON a.course = gi.courseid AND gi.itemmodule = 'assign' AND a.id = gi.iteminstance
WHERE
	asb.latest = 1

AND asb.timemodified IS NOT NULL
AND asb. STATUS = 'submitted'
AND (
	asb.timemodified >= ag.timemodified
	OR ag.timemodified IS NULL
	OR ag.grade IS NULL
) 
 GROUP BY u.id, a.id
ORDER BY u.id,c.category, c.id