Build –> Web Link tool) in courses, and return the Course pk1, Course ID, Course Name, Link Title, and Link URL.
SELECT cm.pk1, cm.course_id, cm.course_name, cc.title, cc.web_url FROM course_contents cc, course_main cm WHERE cc.crsmain_pk1 = cm.pk1 AND cc.cnthndlr_handle='resource/x-bb-externallink' AND cc.web_url = 'http://coehp.uark.edu/colleague/7586.php' -- only search in Enabled courses AND cm.row_status ='0' -- one specific course, comment the next line out if you need a pattern match AND cm.course_id = 'sandbox.cbray.nurs' -- or maybe we need to look at a bunch of matching courses, then uncomment the next line -- AND cm.course_id like '%NURS%' ORDER BY cm.course_id
Results:
|
PK1
|
COURSE_ID
|
COURSE_NAME
|
TITLE
|
WEB_URL
|
|
12812
|
1123-THEUA-NURS-5053-SEC901-10286
|
NURS 5053 – Advanced Nursing Research 1 (1123-THEUA-NURS-5053-SEC901-10286)
|
Nursing News
|
|
|
13482
|
1123-THEUA-NURS-5143-SEC901-9688
|
NURS 5143 – Advanced Pathophysiology (1123-THEUA-NURS-5143-SEC901-9688)
|
Nursing News
|
|
|
39931
|
1129-THEUA-NURS-4003-SEC901-10619
|
NURS 4003 – Transition to Professional Nursing Practices (1129-THEUA-NURS-4003-SEC901-10619)
|
Nursing News
|
To update this Web Link on a course-by-course basis , I used the following:
UPDATE course_contents SET web_url='http://coehp.uark.edu/colleague/nurs/' WHERE web_url='http://coehp.uark.edu/colleague/7586.php' AND CRSMAIN_PK1 = (select pk1 from course_main where course_id = 'sandbox.cbray.nurs')
This requires Update access to the actual Blackboard database itself.
These queries were developed with the assistance of others, including the ASR / Blackboard Reporting Groups, the Bb user community listservs, and Blackboard support.
]]>