The question is a little confusing.  Courses are not cross listed - cross listing "moves" a section from one course to another. If you look at the course_sections table for the section, it con...

The documentation contains details about Filter Identifies a subset of data to fetch from a table. (This feature is not currently implemented.)   When is this going to be made available?  This fea...

The Canvas Data 2 web_logs should contain everything you are after - but only for the last 30 days, and there will be a LOT of data to wade through.  That said, the presence of the user_id  and the  r...

@stimme wrote: maximum number of enrollments one user can have in one course is the product of sections x roles in your Canvas instance. The e.type = 'StudentEnrollment' WHERE clause e...

Yes, we want to preserve getting multiple records for a user.   There are very rare instances in which we have multiple sis_id's for a user,  usually given by accident, but for which we want a rec...

The Canvas Data 2 web_logs should contain everything you are after - but only for the last 30 days, and there will be a LOT of data to wade through.  That said, the presence of the user_id  and the  r...

@LeventeHunyadi wrote: We are looking into providing referential integrity across tables, and have identified approaches how we can make this possible in a scalable manner. I hope this investigat...

Welcome to the world of Canvas Data 2 inconsistency. I am making some assumptions here, as your post is not completely clear to me.  If I understand correctly, You are using the DAP client to maintain...

I know this is a bit old, but I think the answer is that you can't.  There are some things that Instructure has explicitly stated that they only have the most recent version (quiz submissions), bu...

I think you will be disappointed.  You need to add a name.  Just changing the workflow_state to deleted isn't going to fix the constraint problem - the record is not hard deleted, and will still a...