Hi Trish,
The content type availability is stored in a table called:
course_content_handlers
The column is:
available_ind
The SQL snippet below has this table joined to course_main and
content_handlers so you can see some meaningful information on the course
ID's and content types.
select
cm.course_id,
ch.name,
cch.available_ind
from
bb_bb60.course_content_handlers cch,
bb_bb60.course_main cm,
bb_bb60.content_handlers ch
where
cch.crsmain_pk1 = cm.pk1
and cch.content_handlers_pk1 = ch.pk1
and cm.course_id like '2007%'
>Trish wrote...
>>We seem to have magically turned off the availability of
>>certain content types in random courses during rollover :-(
Yes! (sigh)
This random content type turning-off on course copy is a feature intended to
improve the moral fibre of Bb system administrators who would otherwise
spend their Summer's on frivolous pursuits like holidays.
Cathy Colless
University of York
Email: [log in to unmask]
Tel: +44 (0)1904 32 1140
http://vlesupport.york.ac.uk
-----Original Message-----
From: Blackboard/Courseinfo userslist
[mailto:[log in to unmask]] On Behalf Of Trish Murray
Sent: 15 August 2007 14:03
To: [log in to unmask]
Subject: SQL to examine availability of content types
Hiy there,
Does anyone know the SQL to examine content type availability in
Blackboard? We seem to have magically turned off the availability of
certain content types in random courses during rollover :-(
Thanks, Trish
|