I'm reaching out to see if anyone has a query that pulls grade book data from across multiple courses. Any help is greatly appreciated!
I have this one that looks for a specific column across multiple courses... you can comment out stuff.
from ATTEMPT A
INNER JOIN gradebook_grade gg ON a.gradebook_grade_pk1 = gg.pk1
INNER JOIN gradebook_main gm ON gg.gradebook_main_pk1 = gm.pk1
INNER JOIN course_users cu ON gg.course_users_pk1 = cu.pk1
INNER JOIN course_main cm on cu.crsmain_pk1 = cm.pk1
INNER JOIN users u ON cu.users_pk1 = u.pk1
INNER JOIN course_main cm on gm.CRSMAIN_PK1 = CM.PK1
INNER JOIN ATTEMPT a ON gg.LAST_ATTEMPT_PK1 = A.PK1
WHERE cm.COURSE_ID LIKE '1179-THEUA-WCOB-1111%'
AND gm.TITLE LIKE 'Business Brief%'
-- and U.USER_ID = 'USER_ID_HERE'
ORDER BY U.USER_ID, CM.COURSE_ID, GM.PK1, GM.TITLE
Thank you, Chris!
Glad to hear from you.
Note that the database may not always hold the most up to date grade for calculated items. Since those items are computed on the fly, you need to use API to ensure you always get the correct value.
Thanks for your feedback, Jeff!
Would you please direct me to some kind of resource in that regard?
General information about working with the REST API is here:Getting Started With REST
While not exactly what you are looking to do, there is a useful thread on getting grades via API here:
REST APIs for Student Grades & Assignments Due
Thank you, Jeff.
We're in the process of doing that via SQL!
Retrieving data ...