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

Denormalize the assign_submission and assign_grade tables (a little)

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.7
    • Fix Version/s: 2.8
    • Component/s: Assignment

      Description

      Currently they contain multiple entries for the attempt from the same student. The only way to get the "last" attempt is to do a subquery to determine the max. It would be much easier if there was a lastattempt number stored in the user_flags table, we could then simplify all the nasty joins in mod_assign. The edge case is group assignments, which will need to work correctly.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              damyon Damyon Wiese
              Reporter:
              damyon Damyon Wiese
              Peer reviewer:
              Frédéric Massart
              Integrator:
              Dan Poltawski
              Tester:
              Dave Cooper
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Nov/14