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

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

                Dates

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