Hello,
We want to be able to run configurable reports to list all submitted but ungraded assignments. We use scale grades.
I've tried this:
SELECT
u.firstname AS"First",
u.lastname AS"Last",
c.fullname AS"Course",
a.name AS"Assignment"
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?
Thank you
Tania