AnsweredAssumed Answered

SQL queries for BTBB

Question asked by sc0076439 on Jul 15, 2019
Latest reply on Jul 22, 2019 by sc0076439

Hi,

we are on MH so we need to build by ourselves the Oracle SQL queries.

Do you have some hints for doing this properly? Is the Open DB documentation reliable or not for BTBB support https://help.blackboard.com/Learn/Administrator/Hosting/Databases/Open_Database_Schema ?

 

For instance I wrote this query

SELECT CM.COURSE_ID, CM.BATCH_UID, CM.COURSE_NAME, CM.ROW_STATUS, CM.SERVICE_LEVEL, CM.COURSE_DESC, DSK.BATCH_UID, CAT.CATEGORY, T.NAME
FROM AS_CORE.COURSE_MAIN CM
LEFT OUTER JOIN AS_CORE.DATA_SOURCE DSK
ON CM.DATA_SRC_PK1=DSK.PK1
LEFT OUTER JOIN AS_CORE.CATEGORY CAT
ON CM.PK1 = CAT.CRSMAIN_PK1
LEFT OUTER JOIN AS_CORE.COURSE_TERM CT
ON CM.PK1 = TERM.CRSMAIN_PK1
LEFT OUTER JOIN AS_CORE.TERM T
ON CT.TERM_PK1 = T.PK1

But it seems not to work (according to BTBB support). I want to have from Bb Support a list of all courses with their description, category, DSK, Term. Of course, Term and Category should be there if they are populated for that course. 

Outcomes