Hi Castillo, I am really appreciate your help anyway J

Regards,

Mahmoud

 

 

 

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.

 

L.

 

 

 

 

Dears,

Any update!!!

Regards,

Mahmoud

 

Mahmoud Soliman Ahmed Soliman
Blackboard Administrator
Information Technology Services Department
Tel.: +974 4403 3454
Fax: +974 4403 3401

 

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

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. رؤيتنا: أن تصبح جامعة قطر نموذجا للجامعة الوطنية في المنطقة، تتميز بنوعية التعليم والأبحاث، وبدورها الرائد في التنمية الاقتصادية والاجتماعية.