[MDL-73574] WS mod_assign_get_grades is not returning all group submission grades - Moodle Tracker

XML

Word

Printable

When a teacher reviews grading table, grading status differ from web and app.

The problem is that the WS is not returning grades on group submissions when there are no submission for the user.

On gradingtable.php the SQL that defines the table information says:

 // For group assignments, there can be a grade with no submission.

        $from .= ' LEFT JOIN {assign_grades} g

                            ON g.assignment = :assignmentid2

                           AND u.id = g.userid

                           AND (g.attemptnumber = s.attemptnumber OR s.attemptnumber IS NULL) ';

While on the WS is only checking:

[...] AND s.attemptnumber = ag.attemptnumber

I think we should add the "OR s.attemptnumber IS NULL" to the SQL.

blocks

MOBILE-3787 Assignment - Submission in group status are not correct

Component watchers:: Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie