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

    • 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.

      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.

            moodle.com Moodle HQ
            jarens Jason Arens
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.