Hi Castillo, I am really appreciate your help anyway ☺
Regards,
Mahmoud
Mahmoud Soliman Ahmed Soliman
Blackboard Administrator
Information Technology Services Department
Tel.: +974 4403 3454
Fax: +974 4403 3401
From: Blackboard/Courseinfo userslist [mailto:[log in to unmask]] On Behalf Of Ra?l Castillo
Sent: Monday, January 26, 2015 3:27 PM
To: [log in to unmask]
Subject: Re: Test results SQL query from the grade center
Hi Mahmoud,
We worked about it many years ago, in old versions of BB, we realized this data are stored as xml in the database and it’s very complicated to extract it.
We have this query, to show us the grades in the gradecenter:
SELECT COURSE_MAIN.BATCH_UID AS EXTERNAL_COURSE_KEY, COURSE_MAIN.COURSE_ID, COURSE_MAIN.COURSE_NAME, GRADEBOOK_MAIN.TITLE,
USERS.BATCH_UID AS EXTERNAL_PERSON_KEY, USERS.USER_ID, USERS.FIRSTNAME, USERS.LASTNAME, ATTEMPT.SCORE, ATTEMPT.GRADE,
GRADEBOOK_MAIN.POSSIBLE
FROM COURSE_MAIN INNER JOIN
GRADEBOOK_MAIN ON COURSE_MAIN.PK1 = GRADEBOOK_MAIN.CRSMAIN_PK1 INNER JOIN
GRADEBOOK_GRADE ON GRADEBOOK_MAIN.PK1 = GRADEBOOK_GRADE.GRADEBOOK_MAIN_PK1 INNER JOIN
COURSE_USERS ON GRADEBOOK_GRADE.COURSE_USERS_PK1 = COURSE_USERS.PK1 INNER JOIN
USERS ON COURSE_USERS.USERS_PK1 = USERS.PK1 INNER JOIN
ATTEMPT ON GRADEBOOK_GRADE.PK1 = ATTEMPT.GRADEBOOK_GRADE_PK1
WHERE (COURSE_MAIN.PK1 = ???????) AND (USERS.LASTNAME = ‘???????’)
But I think this isn’t you need.
☹.
______________________
Raúl Castillo Fernández
IE Business School
Departamento de Tecnologías Docentes
Vicedecanato de Learning Innovation
C/ María de Molina nº31 8ª Planta
28006 - Madrid
e-mail: [log in to unmask]<mailto:[log in to unmask]>
Tfno: (34) 917875134
De: Blackboard/Courseinfo userslist [mailto:[log in to unmask]] En nombre de Mahmoud Soliman Ahmed Soliman
Enviado el: domingo, 25 de enero de 2015 6:02
Para: [log in to unmask]<mailto:[log in to unmask]>
Asunto: Re: Test results SQL query from the grade center
Dears,
Any update!!!
Regards,
Mahmoud
Mahmoud Soliman Ahmed Soliman
Blackboard Administrator
Information Technology Services Department
Tel.: +974 4403 3454
Fax: +974 4403 3401
From: Mahmoud Soliman Ahmed Soliman
Sent: Thursday, January 22, 2015 8:41 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Test results SQL query from the grade center
Hello everyone,
Kindly could you help me in finding SQL query,
The query is about downloading the test results from the grade center. The query is expected to generate a sheet that contains the student names and IDs in columns with their marks in each question in rows.
Regards,
Mahmoud
Mahmoud Soliman Ahmed Soliman
Blackboard Administrator
Information Technology Services Department
Tel.: +974 4403 3454
Fax: +974 4403 3401
[Qatar University]<http://www.qu.edu.qa>[QU on Facebook]<https://www.facebook.com/qataruniversity> [QU on Twitter] <https://twitter.com/qataruniversity> [QU on YouTube] <http://www.youtube.com/qataruniversity> [QU on LinkedIn] <http://www.linkedin.com/company/43068> [QU on Instagram] <http://instagram.com/qataruniversity> [QU on Google+] <https://plus.google.com/+qataruniversity/posts>
Our Vision: Qatar University shall be a model national university in the region, recognized for high quality education and research, and for being a leader of economic and social development.
رؤيتنا: أن تصبح جامعة قطر نموذجا للجامعة الوطنية في المنطقة، تتميز بنوعية التعليم والأبحاث، وبدورها الرائد في التنمية الاقتصادية والاجتماعية.
