Some LMS classes with group_info.authority_provided_id do not contain columns like group_info.tool_consumer_instance_name
- Dominant language
- Python
- Stars
- 53
- Forks
- 16
- Avg merge
- 14d 5h
- Merged PRs (30d)
- 14
Description
In the Analytics Sandbox:
```
SELECT
gi.*,
g.*,
u.*
FROM
"group" g
left join "group_info" gi on g.authority_provided_id = gi.authority_provided_id
left join "user" u on g.creator_id = u.id
WHERE
g.created > '2020-01-01' AND
u.authority = 'lms.hypothes.is' AND
gi.context_title is not NULL AND
gi.tool_consumer_instance_name is NULL
order by
g.created DESC,
u.display_name
```
I find 33 classes made since 2020-01-01 that have a group_info row with no tool_consumer_instance_name. 31 Look like they’re Canvas, 2 look like Sakai.
LMS info is from tool_consumer_instance_guid for Sakai, and in custom_canvas_api_domain for Canvas.
Some of these are obviously test or sandbox courses, but some of them look like genuine LMS courses.
I've asked a partner school (they have 4 classes on this list and 2 classes that **do** have group_info.tool_consumer_instance_name) if there's a difference between their classes on their end, and I'll add that info here if they get back to me.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.