SQL help - Quiz results

SQL help - Quiz results

by Milo Milo -
Number of replies: 3

Hi

I'm really new at this and I need obtain the result of a specific quiz, the problem is that I need each selected answer value by user.
I have been trying out some SQL's but i can't find the right one.
Someone have any idea about how this can be done?

best regards

Average of ratings: Useful (1)
In reply to Milo Milo

Re: SQL help - Quiz results

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

This should serve as a starting point.

http://docs.moodle.org/dev/Overview_of_the_Moodle_question_engine#Detailed_data_about_an_attempt

Average of ratings: Useful (2)
In reply to Tim Hunt

Re: SQL help - Quiz results

by Milo Milo -

Thank you very much!!! Now I can figure it out how to do this..

Again, thanks men smile

Average of ratings: -
In reply to Milo Milo

Re: SQL help - Quiz results

by Milo Milo -

Have another question about this..

Where I can find the function (Code - SQL insert) that makes the insert of the user selected options for a quiz??
I need to intervene that function so I can use that data and send them to another table (custom)

Average of ratings: -