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

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.

Find more posts tagged with

Canvas Data 2

Accepted answers

All comments

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.

Unanswered Questions

CD2 assignments data changed/updated?
In our CD2 Assignments table, we're noticing a weird discrepancy: - ran a query in 2/2025 and saw 50 assignments in one class from 2018 - ran the query in 2/2026 and there were fewer (only 40 assignments) We looked at the Assignments table, specifically at the ts field. On 10/1/25, 100% of the records in that table (6.5…
Error initializing large table using dap on python 3.14
Hi — I've been struggling to initialize our "submissions" table using the dap CLI and I've narrowed down the problem to Python 3.14. I'm able to successfully run the same exact initdb command (on the same EC2 instance) under Python 3.13 and 3.12. On Python 3.14.2, the import successfully processes about 34 million records…
EDUCAUSE Insights: Data and Decision-Making
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
Problems with GraphQL in User Pageviews reports
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
Metrics Easy Button
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…