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

Autosubmit does not use LATEHANDLING field of SAM_PUBLISHEDACCESSCONTROL_T table

    Details

    • Previous Issue Keys:
      SAM-2702
    • Test Plan:
      Hide

      -Set up autosubmit in Samigo to send pending submissions.

      -Create an assessment working copy with Late submissions accepted: "Yes, until <DATE1>".

      -Publish a copy of the assessment but select in Late submissions "No, not after due data" and set the availability date as "<DATE2>" when <DATE2> is later than <DATE1>.

      -Make the published test and leave an exam without sending so it is "In progress" after the due date.

      -Run the autosubmit job. The test "in progress" is never sent.

      Show
      -Set up autosubmit in Samigo to send pending submissions. -Create an assessment working copy with Late submissions accepted: "Yes, until <DATE1>". -Publish a copy of the assessment but select in Late submissions "No, not after due data" and set the availability date as "<DATE2>" when <DATE2> is later than <DATE1>. -Make the published test and leave an exam without sending so it is "In progress" after the due date. -Run the autosubmit job. The test "in progress" is never sent.

      Description

      Autosubmit job uses a query in AssessmentGradingFacadeQueries.java that processes assessments where the next condition is true:

      and a.attemptDate <= c.retractDate

      However, if late submissions are not accepted in assessment configuration, the retractDate should not be used in this query. But the date remains in the database field and the query does not return pending submissions in this case.

      The right query should have this condition:

      and (a.attemptDate <= c.retractDate or (c.dueDate < now() and c.lateHandling=2))

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  daniel.merino Daniel Merino Echeverría
                  Reporter:
                  daniel.merino Daniel Merino Echeverría
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code