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

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

    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

              moodle.com Moodle HQ
              jarens Jason Arens
              Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: