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
    • Fix Version/s: 19.1, 20.0
    • 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

          Zeplin

            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 Integration