-
thanks for that - sadly though we also need guest access at a system level as we have some external 'open day' type courses so people who are thinking of coming here can see what they will get. So is there another way? Thanks Dave
-
Hi, is it possible to give access to course materials to students not enrolled in that course. I know about guest access and that works ok, but that in theory opens up access to the internet if you know the URL. We would like something to be used when students choose their next year courses, so that can view stuff which has been opened up to them by
-
yep, worked the way you suggest, pk1 of course_contents was the link_source_pk1 and the course_contents_pk1 was obviously from course_contents
-
excellent, thanks very much - wanted to know about that table for ages. Quick follow up - how do you find out how about these tables, it's not listed openly in the open database for this purpose and not obvious what it is for (without going through each table)
-
Hi, we are writing a web page to print out assessment information from blackboard, mainly to be used a sanity checker for making sure we have the settings correct, I am having trouble with the SQL here is what I have so far (excuse the length here) select cm.course_id, qti.title, cc.start_date, cc.end_date, ca.pk1 as capk1, cm.pk1 as cmpk1, cc.available_ind
-
whats the error?
-
excellent, thats exactly what i needed it was a further join to attempt and qti_result_data to get the info, that conversion there gives a nice bit of XML with the users response and the mark they got for that question. Thanks for digging that out
-
thanks MIke, got the info I want, in gradebook_grade. The data seems to be in qti_result_data which is just a massive random string so I guess the logic is in the application to pull that out. I'll see if support can tell me a way
-
HI, we have had to restore a database from a couple of weeks ago due to some data loss. What I would like to do is extract the score for a specific assessment from this restored database for a specific student. I would rather not put a front end onto it as we dont have the spare servers (or the content system for this period) does anyone know the SQL
-
you can work around this by select always show scroll bars, you can do that by going to system preferences, general and always showing scroll bars - should show up then,