Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-30370 Meta: Oracle SQL issues
  3. MDL-29937

Sorting assignment submissions by comment or grade

    XMLWordPrintable

    Details

    • Database:
      PostgreSQL, Oracle
    • Testing Instructions:
      • Create an assignment with three assigned users.
      • Submit assignments for two of these users.
      • Mark one submission as 100.
      • Sort by Grade.
    • Affected Branches:
      MOODLE_20_STABLE, MOODLE_21_STABLE, MOODLE_22_STABLE

      Description

      When sorting the assignments by grades or comments those students that have submitted assignments will be sorted differently to those who have submitted no assignment when the grade or comment field is empty.

      For example when you sort by grade in descending order you may get:

      • No Grade
      • 97
      • No Grade
        as the order. This is caused when one of these No Grade results is from a student who has submitted an assignment that has not been graded and the other from a student who has not submitted an assignment at all.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              moodle.com moodle.com
              Reporter:
              jarens Jason Arens
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: