Using admin SQL to match quiz stats
Credit (Jason Rodgers): Has anyone found a way using the admin SQL to figure out what mdl_quiz_statistics match up to what mdl_quiz. Currently there is no quizid, it is a tracker item 75197, but would love to have a way to get the two linked now.
-
Credit (Cristian Duque):
I consulted with several people in the team and, well, we don't have good news.
As it was explained to me, the quiz table is hashed and in most cases MySQL is unable to make joins using hashed tables, let alone decrypt it.
Furthermore, quiz statistics are only generated when you run the report from the front end. We'd guess you could do a real-time pairing, if you start with an empty quiz statistics table, then run a report on a quiz, then check the statistics again. That can point you towards the specific quiz. Admittedly this sounds cumbersome and there's a dozen scenarios where it just wouldn't work.
I've also asked if a tool like IntelliBoard could help here, but since they work with Moodle's already available data, there doesn't seem to be a way here either.
0
Please sign in to leave a comment.
Comments
1 comment