Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-41828

Assignment 12 Conversion should not set a grade override for non project

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 12.6, 19.0, 20.0 [Tentative]
    • Fix Version/s: 19.1, 20.0 [Tentative]
    • Component/s: Assignments
    • Labels:
      None
    • 19 status:
      Resolved
    • Conversion Script Required:
      Yes
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      For non group projects the assignment conversion was setting the grade on the AssignmentSubmissionSubmitter. The only time a grade override would be needed is for group project submissions.

       SQL to clean up grades:

      update asn_submission_submitter ss
       join asn_submission s on (s.SUBMISSION_ID = ss.SUBMISSION_ID)
       join asn_assignment a on (s.ASSIGNMENT_ID = a.ASSIGNMENT_ID)
       set ss.GRADE = NULL 
       where a.IS_GROUP is FALSE and s.grade is not NULL and ss.grade is not NULL;

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ern Earle R Nietzel
                Reporter:
                ern Earle R Nietzel
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code