CD2 Pulling out which students have been assigned to a particular assignment

[MattLaidler]

Hi all,

Looking for some help on how on which table contains the details of who an assignemnet has been assigned to. I have looked under submissions but this does not seem to be a complete list. If anyone can help and share some insight on how and where I can get this info from CD2 it would be appreciated.

[stimme]

The tables with details about specific Assign To settings are canvas.assignment_override_students and canvas.assignment_overrides.

I did a spot check with an assignment I knew to be assigned to just 2 individuals in the Canvas application. When I selected the count from canvas.submissions where that assignment_id matched, the result was 2. I am curious what discrepancy you found between the application Assign To field and the count or workflow_state in canvas.submissions.

[MattLaidler]

Hi,

So I am looking for the list of students before they submit, I currently have an assignment assigned to a single student, (the student has not yet submitted), yet when I view the submissions list the only student on the list is the Canvas Test Student. This has been my test data as I try to work out how to reliably build a list of assignments that are expected to submit.

[stimme]

Generally speaking, the canvas.submissions table contains expected submissions as well as attempted submissions. The workflow_state field includes "unsubmitted" as a value. To get a sense of the number of records on the table where students have not submitted but might, try this:

SELECT COUNT(*) 
FROM canvas.submissions 
WHERE workflow_state = 'unsubmitted' 
AND assignment_id NOT IN (
  SELECT id 
  FROM canvas.assignments 
  WHERE submission_types IN ('none','ungraded','on_paper')
)
;

I am puzzled to hear that your canvas.submissions table did not include a record for the one student to whom your test assignment is assigned. Be sure to let enough time pass between creating an assignment in Canvas and refreshing CD2 so that it will be up to date. If your table does not seem to be updating, you might try troubleshooting with Instructure Support.