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

Submitted/Ungraded submission counts in the assignments list are not correct for non-electronic assignments

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 12.0
    • Fix Version/s: 12.0, 19.0
    • Component/s: Assignments
    • Labels:
      None
    • 12 status:
      Resolved
    • Test Plan:
      Hide
      1. Prepare a site with some students
      2. Create an assignment of Non-electronic type.
      3. As instructor, check the IN/NEW column in the assignments list, it should display 0/0
      4. View the submissions list clicking in the 0/0 column or "View Submissions".
      5. It should display the list of students.
      6. Go back to the assignments list, it should display N/N where N is the number of students.
      7. View the submissions again and grade one of the submissions.
      8. Go back to the assignments list, it should display N/(N-1) where N is the number of students.
      Show
      Prepare a site with some students Create an assignment of Non-electronic type. As instructor, check the IN/NEW column in the assignments list, it should display 0/0 View the submissions list clicking in the 0/0 column or "View Submissions". It should display the list of students. Go back to the assignments list, it should display N/N where N is the number of students. View the submissions again and grade one of the submissions. Go back to the assignments list, it should display N/(N-1) where N is the number of students.

      Description

      Submitted/Ungraded submission counts in the assignments list are not correct for non-electronic assignments.

      The 11.x queries are different than the 12.x queries, removes some fields of the query:

      Sakai 11 queries:
      SELECT count( * ) FROM sakai.asn_submission where assignment_id = '15c71300-3efa-456f-8769-421b519fe880' and submitted=true;
      SELECT count( * ) FROM sakai.asn_submission where assignment_id = '15c71300-3efa-456f-8769-421b519fe880' and submitted=true and graded=false;

      Sakai 12 queries:
      SELECT count( * ) FROM sakai.asn_submission where assignment_id = '15c71300-3efa-456f-8769-421b519fe880' and submitted=true and user_submission=true and submitted_date is not null;
      SELECT count( * ) FROM sakai.asn_submission where assignment_id = '15c71300-3efa-456f-8769-421b519fe880' and submitted=true and graded=false and submitted_date is not null;

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  farreri Miguel Pellicer
                  Reporter:
                  farreri Miguel Pellicer
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code