We want to be able to run configurable reports to list all submitted but ungraded assignments. We use scale grades.
I've tried this:
FROM prefix_assignment_submissions AS asb
JOIN prefix_assignment AS a ON a.id = asb.assignment
JOIN prefix_user AS u ON u.id = asb.userid
JOIN prefix_course AS c ON c.id = a.course
JOIN prefix_course_modules AS cm ON c.id = cm.course
WHERE asb.grade <0AND cm.instance = a.id
AND cm.module =1
ORDERBY c.fullname, a.name, u.lastname
But it's giving no data, which is definitely not correct. Can anyone suggest anything?