Moodle SCORM/Quiz DB query

Re: Moodle SCORM/Quiz DB query

by Benjamin Ellis -
Number of replies: 4
Picture of Particularly helpful Moodlers

It is not the table column that has the data, it is the record's element and the value fields that are relevant.

The element cmi.core.score.raw's value is the score/grade and the element cmi.core.lesson_status' value is the status (passed/completed/failed etc etc) see https://scorm.com/scorm-explained/technical-scorm/run-time/run-time-reference/#section-2 for SCORM 1.2 elements details.

However, your table does not appear to be standard - my 3.5 table does not have the fields after the timemodified field.





Average of ratings: Useful (1)
In reply to Benjamin Ellis

Re: Moodle SCORM/Quiz DB query

by T K -
Hi Benjamin,
Thanks for your reply. Yes there seems to be some custom fields added by previous administrators but not in use now.

I dont see the cmi.core.score.raw rows, I only see cmi.core.lesson_status as either complete or incomplete
Average of ratings: -
In reply to Benjamin Ellis

Re: Moodle SCORM/Quiz DB query

by T K -
Ok some update here, i see it now, thanks so much Benjamin!
Average of ratings: -
In reply to Benjamin Ellis

Re: Moodle SCORM/Quiz DB query

by T K -
one more thing Benjamin, for a given quiz or any grades, is it possible to view the pass/fail status on the DB?
Average of ratings: -
In reply to T K

Re: Moodle SCORM/Quiz DB query

by Benjamin Ellis -
Picture of Particularly helpful Moodlers
Yes, the element cmi.core.lesson_status' value is the status (passed/completed/failed etc etc).  This value is set by the SCORM object.
Average of ratings: -