About

KeithSmith_au
Rank:
Community Contributor
Title:
Solution Architect
Joined:
Jul 14, 2022 5:45:52 PM
Posts:
54
Solutions:
5
Likes Received:
36
Bio:
An amazing Instructure Community member

Most Liked Posts

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 contains tw...
Likes: 3
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...
Likes: 3
@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 excludes the enro...
Likes: 2
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 record ...
Likes: 2
You have covered it in your following post, but for anybody else encountering this - you have to add the name, not just delete the section, as deleting it will still have the CD2 data element present ...
Likes: 2

Most Recent Posts

@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 investigation ...
Apr 15, 2024 5:59:19 PM
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...
Apr 15, 2024 3:16:45 PM
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), but I ...
Apr 3, 2024 6:21:36 PM
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 appea...
Apr 3, 2024 3:19:09 PM
I don't think this is ever going to be possible or feasible.  Canvas Data 2 operates as a Data Lake, where data is ingested (with some transformation), then available for efficient extract.  The filte...
Apr 3, 2024 2:27:38 PM

Latest Badges

5 Solutions Provided

5 Solutions Provided

Earned: 2024-04-30

50 Replies Posted

50 Replies Posted

Earned: 2024-04-03

25 Likes Received

25 Likes Received

Earned: 2024-03-06

50 Logins Completed

50 Logins Completed

Earned: 2024-01-25