Im trying to make a submission report and in that report it must stat how many "assignments" needs grading
As it is now i have made an sql that gets the entries from assign_submissions and assign_grades, and the deduct the numbers to see if any needs grading.
http://screencast.com/t/uFS5m0QyOHOh
"$sql_count = "SELECT count(ass.id) AS submissions, count(ag.id) AS gradedsub
FROM {assign_submission} AS ass
LEFT JOIN {assign_grades} AS ag ON ag.assignment = ass.assignment
WHERE ass.assignment = $assignments->id";
My question is - is there an easier way to get this information - i have assignment id and course id.
Kind regards
Henrik Sune Pedersen