Hi everyone,
We had an interesting question from our librarians. They are trying to identify courses that link to one of their resources. They provide a URL to the instructors and the instructors make this link/URL available in their courses. They would like to identify the Bb courses using this URL/resource. I imagine that the instructors have made a Web link in their content or made a link in a content area (Item or Blank page). Would it be possible to search the database for a URL string so it identifies the courses using this resource? Is there a query around that looks up for weblinks in courses? We have ASR access.
Thank you in advance for any insight on this.
Best,
Lorena
For OpenDB, I've used this to search for links in a course content web link tool:
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'
-- AND cc.web_url LIKE '%tips.uark.edu%'
AND cc.web_url LIKE '%library.uark.edu%'
ORDER BY
cc.web_url
I have a different query for things linked in the course menu.
And a different query to look for text within Items....
SELECT
cm.course_id, cm.course_name,
-- cc.cnthndlr_handle as "Publisher Tool",
cc.title,
cc.MAIN_DATA,
cc.DTCREATED,
cc.DTMODIFIED
FROM
course_contents cc ,
course_main cm
WHERE cc.crsmain_pk1 = cm.pk1
AND cm.row_status ='0'
-- AND cm.available_ind ='Y'
AND (cm.COURSE_ID like '1179-THEUA%' or cm.COURSE_ID like 'MASTER-1179%')
AND cc.MAIN_DATA LIKE '%tips.uark.edu/kaltura-video-tutorials%'
-- AND cc.MAIN_DATA LIKE '%SPSS%'
--AND cc.cnthndlr_handle='resource/x-bb-document'
ORDER BY
cm.course_id;