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

Migrate the history report to use table_sql

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide

      SETUP

      1. create a course with:-
        1. Atleast 5 gradeable activities including self graded ones like quiz and scorm and manual graded ones like assignment, essay quiz etc
        2. Atleast 8-10 students
        3. 4-5 teachers
        4. Submissions from multiple students on multiple activities.
      2. Create some manual grade items by going to grade report > categories
      3. As various Teachers grade activites like assign, essay questions etc where required.
      4. Go to grade book and change grades, give feedback etc as various teachers.

      TEST

      1. As a teacher go to gradebook history report - gradebook > history
      2. Test that all data is displayed properly
      3. Test pagination of the sql table, you need 100+ entries for the pagination to show up (alternatively update the tablelog class to reduce this number)
      4. Test various sorting of columns and make sure it works as expected
      5. Test downloading the data in various format, and make sure it works as expected.
      6. Test various filters on top of the page and make sure it works as expected.
      Show
      SETUP create a course with:- Atleast 5 gradeable activities including self graded ones like quiz and scorm and manual graded ones like assignment, essay quiz etc Atleast 8-10 students 4-5 teachers Submissions from multiple students on multiple activities. Create some manual grade items by going to grade report > categories As various Teachers grade activites like assign, essay questions etc where required. Go to grade book and change grades, give feedback etc as various teachers. TEST As a teacher go to gradebook history report - gradebook > history Test that all data is displayed properly Test pagination of the sql table, you need 100+ entries for the pagination to show up (alternatively update the tablelog class to reduce this number) Test various sorting of columns and make sure it works as expected Test downloading the data in various format, and make sure it works as expected. Test various filters on top of the page and make sure it works as expected.
    • Affected Branches:
      MOODLE_28_STABLE
    • Pull Master Branch:
      MDL-46569-master
    • Story Points:
      40
    • Sprint:
      BACKEND Sprint 15

      Description

      • Migrate the table to a table_sql
        • Enable and check the column sorting
        • Enable and check the collapsible columns
      • Implement autoloading of the different classes
      • Use the download feature, rather than the export button
      • Reconsider the columns (which ones to display, what order to use)
      • Make the name of the grader, graded users and grade item clickable
        • Grader and graded go to their profile
        • Grade item could go somewhere, maybe...
      • Do not capitalise the source column values
      • Page navigation should not be displayed above the filter form

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ankit_frenz Ankit Agarwal
              Reporter:
              fred Frédéric Massart
              Peer reviewer:
              Frédéric Massart
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: