Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-58795

gradereport_grader: Sorting the grader report table returns duplicate results when using pages.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.1.5, 3.2.2, 3.3
    • Fix Version/s: 3.2.4, 3.3.1
    • Component/s: Gradebook
    • Labels:
    • Testing Instructions:
      Hide

      Note: These testing instructions test for regression. The nature of the database sorting means that it is not reliably reproducible.
      Note: This should be tested in all four DBs

      1. Create a course.
      2. Enrol at least 13 students
      3. Create an assignment activity and name it as "assign1".
      4. Set the Students per page to 3 at Administration > Grade administration > Setup > Preferences: Grader report.
      5. Go to Grader report page at Administration > Grade administration > Grader Report.
      6. Click the Turn editing on button.
      7. Click the First name column sort to sort the table.
      8. Enter 50 as the grade for the first 11 students. Leave the others as blank.
      9. Make sure you are still on Page 1.
      10. Check that you can sort by each of:
        1. firstname
        2. lastname
        3. email
        4. idnumber
        5. "assignment1" column
      11. Click and sort using the "assignment1" (descending order).
      12. On page 1, record the name of the students.
      13. Click Page 2 and so on...
        1. The returned results should be unique and should not contain duplicates (no repeating of returned results in the pages).
      Show
      Note: These testing instructions test for regression. The nature of the database sorting means that it is not reliably reproducible. Note: This should be tested in all four DBs Create a course. Enrol at least 13 students Create an assignment activity and name it as "assign1". Set the Students per page to 3 at Administration > Grade administration > Setup > Preferences: Grader report. Go to Grader report page at Administration > Grade administration > Grader Report. Click the Turn editing on button. Click the First name column sort to sort the table. Enter 50 as the grade for the first 11 students. Leave the others as blank. Make sure you are still on Page 1. Check that you can sort by each of: firstname lastname email idnumber "assignment1" column Click and sort using the "assignment1" (descending order). On page 1, record the name of the students. Click Page 2 and so on... The returned results should be unique and should not contain duplicates (no repeating of returned results in the pages).
    • Affected Branches:
      MOODLE_31_STABLE, MOODLE_32_STABLE, MOODLE_33_STABLE
    • Fixed Branches:
      MOODLE_32_STABLE, MOODLE_33_STABLE
    • Pull Master Branch:
      MDL-58795-master

      Description

      Currently, the activities sort functionality used in the Grader Report table at Administration > Grade administration > Grader Report returns duplicate results depending on the Students per page setting and the grades for the students.

      Say for example, if you set the student per page to 3 at Administration > Grade administration > Setup > Preferences: Grader report and you have more than 10 students with the same grade for an activity, then the sorting functionality will return a result with duplicate values as you cycle through the table pages (result from 1 page may or appears in another page).

        Attachments

        1. page1.png
          page1.png
          59 kB
        2. page5.png
          page5.png
          46 kB

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Jul/17