Database Query to obtain the quiz individual question responces

Re: Database Query to obtain the quiz individual question responces

by Emma Richardson -
Number of replies: 3
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers

Sorry been out of the office for a while.  Just saw your message.  The sql query that Tim pointed you to should do what you need it to.  quiza is just shorthand for the quizattempts table.

In reply to Emma Richardson

Re: Database Query to obtain the quiz individual question responces

by jaswanth krishna -

yes i know it from the query that quizza is the shord hand for the quiz attempted table , so in order to get my normal implementation . i need to retireve the quiza id of that particular quiz (thats from quiz id ) by that individual student right ??

Let me know if i am missing a point here .

In reply to jaswanth krishna

Re: Database Query to obtain the quiz individual question responces

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers

The quiza id in the last where statement should be all you need.  It would point to the specific attempt - you will need to find that number.  You can do that from the url of the attempt in the web interface.

Average of ratings: Useful (1)
In reply to Emma Richardson

Re: Database Query to obtain the quiz individual question responces

by jaswanth krishna -

Finally Did it Yay!!! Yay for moodle !!!

Thank you Tim and Emma .