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.