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
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.