{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":335786468,"defaultBranch":"main","name":"canvas_queries","ownerLogin":"tl-its-umich-edu","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2021-02-03T23:48:02.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/8292960?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1704386901.0","currentOid":""},"activityList":{"items":[{"before":"6dc8a0b1209663fa04545fd2415f3951f1ad0e9a","after":"122dd00cf3e8126c83587e5cd4659d9aa921b389","ref":"refs/heads/main","pushedAt":"2024-07-03T15:34:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Update rubrics.md\n\nupdated one query without u as the joined table","shortMessageHtmlLink":"Update rubrics.md"}},{"before":"01c5a9af504f9006a5c447f8b0340b50dd1536a2","after":"6dc8a0b1209663fa04545fd2415f3951f1ad0e9a","ref":"refs/heads/main","pushedAt":"2024-06-27T23:03:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Update rubrics.md added assignment id and student id filter","shortMessageHtmlLink":"Update rubrics.md added assignment id and student id filter"}},{"before":"cba81fa734e075e9b9c6111e4aaa67529a5e57c1","after":"01c5a9af504f9006a5c447f8b0340b50dd1536a2","ref":"refs/heads/main","pushedAt":"2024-05-21T15:18:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ziegler1960","name":null,"path":"/ziegler1960","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/42045570?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":"8f83202ba96f289c51612cbbc77081a72d660679","after":"cba81fa734e075e9b9c6111e4aaa67529a5e57c1","ref":"refs/heads/main","pushedAt":"2024-05-02T13:58:22.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Merge pull request #28 from zqian/main\n\nupdate based recent submission data request","shortMessageHtmlLink":"Merge pull request #28 from zqian/main"}},{"before":"df985eec1e53dba4b291335e6c727310553c89d5","after":"8f83202ba96f289c51612cbbc77081a72d660679","ref":"refs/heads/main","pushedAt":"2024-03-12T15:09:39.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Merge pull request #22 from zqian/issue_21\n\nissue #21 query for LTI tool u","shortMessageHtmlLink":"Merge pull request #22 from zqian/issue_21"}},{"before":"bc02d048a22fab91cb34e3d4470b7502876729bc","after":"df985eec1e53dba4b291335e6c727310553c89d5","ref":"refs/heads/main","pushedAt":"2024-03-12T14:53:49.000Z","pushType":"pr_merge","commitsCount":6,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"},"commit":{"message":"Merge pull request #23 from tl-its-umich-edu/jennlove-myla\n\nAdd MiVideo.md & minor updates to enrollments.md and MyLA.md","shortMessageHtmlLink":"Merge pull request #23 from tl-its-umich-edu/jennlove-myla"}},{"before":"0ceaa7bd2cba958a6b46b29a8e52e1fa6751dbed","after":"f464b693ff0144a91ea6c31ce3acd57b4c985003","ref":"refs/heads/jennlove-myla","pushedAt":"2024-03-12T14:52:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"},"commit":{"message":"Changing values to parameters\n\nIn the MiVideo query, this change makes the query more general by using parameters instead of specific values in the query.","shortMessageHtmlLink":"Changing values to parameters"}},{"before":"3de264ebdc521ae32056334c83468033cc502ea7","after":"bc02d048a22fab91cb34e3d4470b7502876729bc","ref":"refs/heads/main","pushedAt":"2024-03-11T13:08:01.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"pushyamig","name":"Pushyami Gundala","path":"/pushyamig","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8579775?s=80&v=4"},"commit":{"message":"adding start and end of the term (#27)","shortMessageHtmlLink":"adding start and end of the term (#27)"}},{"before":"e9c7983297cb061ce7ad668080f8b0a387a95747","after":"3de264ebdc521ae32056334c83468033cc502ea7","ref":"refs/heads/main","pushedAt":"2024-03-06T18:32:17.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"pushyamig","name":"Pushyami Gundala","path":"/pushyamig","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8579775?s=80&v=4"},"commit":{"message":"Calculating the term end date based on RO recommendation (#25)\n\n* Calculating the term end date based on RO recommendation\r\n\r\n* Adding missing interval keyword","shortMessageHtmlLink":"Calculating the term end date based on RO recommendation (#25)"}},{"before":"a75fcf58b72d05225ebe12090468344f915b8250","after":"e9c7983297cb061ce7ad668080f8b0a387a95747","ref":"refs/heads/main","pushedAt":"2024-02-07T21:34:36.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Merge pull request #17 from zqian/issue_16\n\nissue_16 two queries to report Linkedin Learning tool usages","shortMessageHtmlLink":"Merge pull request #17 from zqian/issue_16"}},{"before":"eb79e3a22b317679d2949e1ec1d158baa7f0464b","after":"0ceaa7bd2cba958a6b46b29a8e52e1fa6751dbed","ref":"refs/heads/jennlove-myla","pushedAt":"2024-02-07T19:52:02.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"},"commit":{"message":"Merge branch 'jennlove-myla' of https://github.com/tl-its-umich-edu/canvas_queries into jennlove-myla","shortMessageHtmlLink":"Merge branch 'jennlove-myla' of https://github.com/tl-its-umich-edu/c…"}},{"before":"6baa26fa405eccf62d812cc1720cedc335fdeac5","after":"a75fcf58b72d05225ebe12090468344f915b8250","ref":"refs/heads/main","pushedAt":"2024-01-30T19:55:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Update enrollments.md, fixed the markdown issue for showing query block.","shortMessageHtmlLink":"Update enrollments.md, fixed the markdown issue for showing query block."}},{"before":"e65f32dea236f2af5a90c2b65d5ea5a7a6489a8f","after":"6baa26fa405eccf62d812cc1720cedc335fdeac5","ref":"refs/heads/main","pushedAt":"2024-01-30T19:52:38.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Merge pull request #18 from tl-its-umich-edu/jennlove-myla\n\nAdds gradebook, MyLA, & enrollment queries","shortMessageHtmlLink":"Merge pull request #18 from tl-its-umich-edu/jennlove-myla"}},{"before":"bafddad3c8701ae2bffc51bbc8188d58fe199278","after":"eb79e3a22b317679d2949e1ec1d158baa7f0464b","ref":"refs/heads/jennlove-myla","pushedAt":"2024-01-30T19:52:19.000Z","pushType":"push","commitsCount":6,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Merge branch 'main' into jennlove-myla","shortMessageHtmlLink":"Merge branch 'main' into jennlove-myla"}},{"before":"64a80c65f28e4e579ee8dadecd6e1f8be031aa78","after":"e65f32dea236f2af5a90c2b65d5ea5a7a6489a8f","ref":"refs/heads/main","pushedAt":"2024-01-12T15:54:39.000Z","pushType":"pr_merge","commitsCount":5,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Merge pull request #20 from zqian/issue_19\n\nissue_19 added query for enrolled course with instructors","shortMessageHtmlLink":"Merge pull request #20 from zqian/issue_19"}},{"before":"64a80c65f28e4e579ee8dadecd6e1f8be031aa78","after":"bafddad3c8701ae2bffc51bbc8188d58fe199278","ref":"refs/heads/jennlove-myla","pushedAt":"2024-01-10T20:52:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"},"commit":{"message":"Adds gradebook, MyLA, & enrollment queries","shortMessageHtmlLink":"Adds gradebook, MyLA, & enrollment queries"}},{"before":null,"after":"64a80c65f28e4e579ee8dadecd6e1f8be031aa78","ref":"refs/heads/jennlove-myla","pushedAt":"2024-01-04T16:48:21.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"},"commit":{"message":"Fixes markdown syntax","shortMessageHtmlLink":"Fixes markdown syntax"}},{"before":"e2cea3dcbad221249b3b876d72e7b18543d39f5c","after":null,"ref":"refs/heads/jennlove-wilson-center","pushedAt":"2024-01-04T16:47:30.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"}},{"before":"6837f46c8b0031df2c7ddda3cdac48f28709b5cc","after":"64a80c65f28e4e579ee8dadecd6e1f8be031aa78","ref":"refs/heads/main","pushedAt":"2024-01-04T16:18:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"},"commit":{"message":"Fixes markdown syntax","shortMessageHtmlLink":"Fixes markdown syntax"}},{"before":"389036f81fd02cb288eebdc17a335c89e30a6ab0","after":"6837f46c8b0031df2c7ddda3cdac48f28709b5cc","ref":"refs/heads/main","pushedAt":"2024-01-04T16:14:39.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"},"commit":{"message":"Merge pull request #15 from tl-its-umich-edu/jennlove-wilson-center\n\nadd enrollments and submissions queries to CD2","shortMessageHtmlLink":"Merge pull request #15 from tl-its-umich-edu/jennlove-wilson-center"}},{"before":"f6553dd9fd370d2b5ea7e3ebd806b4c548841c2c","after":"e2cea3dcbad221249b3b876d72e7b18543d39f5c","ref":"refs/heads/jennlove-wilson-center","pushedAt":"2024-01-04T01:45:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"},"commit":{"message":"reorganized files into enrollments.md and submissions.md\n\nDeleted the Wilson Center specific queries and created more generic, reusable versions of the queries.","shortMessageHtmlLink":"reorganized files into enrollments.md and submissions.md"}},{"before":null,"after":"f6553dd9fd370d2b5ea7e3ebd806b4c548841c2c","ref":"refs/heads/jennlove-wilson-center","pushedAt":"2024-01-04T00:05:51.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"jennlove-um","name":"Jennifer Love","path":"/jennlove-um","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/39634416?s=80&v=4"},"commit":{"message":"add queries used for Wilson Center Training site support\n\nThese queries have been used to get quiz information and student enrollment information to support the Wilson Center's need to track which students have passed quizzes as a requirement to use lab equipment.","shortMessageHtmlLink":"add queries used for Wilson Center Training site support"}},{"before":"351ea510f6a726047106832bb208b4a240eb9d18","after":"389036f81fd02cb288eebdc17a335c89e30a6ab0","ref":"refs/heads/main","pushedAt":"2023-12-21T16:11:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Create delete_events_in_course.md\n\nA event store query for course delete events","shortMessageHtmlLink":"Create delete_events_in_course.md"}},{"before":"2f177e9321be17aa05d86adc71765a299ddd9aae","after":"351ea510f6a726047106832bb208b4a240eb9d18","ref":"refs/heads/main","pushedAt":"2023-12-15T19:46:36.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"pushyamig","name":"Pushyami Gundala","path":"/pushyamig","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8579775?s=80&v=4"},"commit":{"message":"Adding current gpa,credit hours info and notes on SQ (#13)","shortMessageHtmlLink":"Adding current gpa,credit hours info and notes on SQ (#13)"}},{"before":"e3d4a5b5ea9e878b473efb33437006c909538364","after":"2f177e9321be17aa05d86adc71765a299ddd9aae","ref":"refs/heads/main","pushedAt":"2023-12-01T02:39:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Update to UDP CD2 schema \"udp-umich-prod.canvas\"","shortMessageHtmlLink":"Update to UDP CD2 schema \"udp-umich-prod.canvas\""}},{"before":"502e11dd6cec110bd589c55fb8d4fc350e077e50","after":"e3d4a5b5ea9e878b473efb33437006c909538364","ref":"refs/heads/main","pushedAt":"2023-08-17T19:19:25.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"lsloan","name":"Mr. Lance E Sloan «UMich»","path":"/lsloan","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20786?s=80&v=4"},"commit":{"message":"Merge pull request #10 from lsloan/LTI-tool-SQL-fixes\n\n28aae2f — fix LTI course list query: Corrects mistakes and problems I found in this query.","shortMessageHtmlLink":"Merge pull request #10 from lsloan/LTI-tool-SQL-fixes"}},{"before":"187a8a49b318ce104cf7b3ecba028bc3d1fe3c94","after":"502e11dd6cec110bd589c55fb8d4fc350e077e50","ref":"refs/heads/main","pushedAt":"2023-08-17T15:58:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"add rubrics query based on CD2 data","shortMessageHtmlLink":"add rubrics query based on CD2 data"}},{"before":"91e330fddb4c65c6e59bd54984bf920bbcb36fa5","after":"187a8a49b318ce104cf7b3ecba028bc3d1fe3c94","ref":"refs/heads/main","pushedAt":"2023-08-09T16:58:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"zqian","name":"Zhen Qian","path":"/zqian","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/359944?s=80&v=4"},"commit":{"message":"Update LTI_tool.md\n\nremoved the extra ',' character inside sql query","shortMessageHtmlLink":"Update LTI_tool.md"}},{"before":"eebc448245425b20a5b84e7d2cc18ea44b533fe7","after":"91e330fddb4c65c6e59bd54984bf920bbcb36fa5","ref":"refs/heads/main","pushedAt":"2023-07-18T20:18:28.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"pushyamig","name":"Pushyami Gundala","path":"/pushyamig","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8579775?s=80&v=4"},"commit":{"message":"Adding first and last name to v1 query (#9)","shortMessageHtmlLink":"Adding first and last name to v1 query (#9)"}},{"before":"615574038268c12982530ca0c07258629e3a4418","after":"eebc448245425b20a5b84e7d2cc18ea44b533fe7","ref":"refs/heads/main","pushedAt":"2023-04-18T13:48:18.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"pushyamig","name":"Pushyami Gundala","path":"/pushyamig","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8579775?s=80&v=4"},"commit":{"message":"Matview context store BQ queries(#6)","shortMessageHtmlLink":"Matview context store BQ queries(#6)"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEdg2KbAA","startCursor":null,"endCursor":null}},"title":"Activity · tl-its-umich-edu/canvas_queries"}