SQL Report with Quiz Questions and Answers for all Courses

Ynt: Re: SQL Report with Quiz Questions and Answers for all Courses

by Uğur Feyzullahoğlu -
Number of replies: 2

I solved smile

Average of ratings: -
In reply to Uğur Feyzullahoğlu

Re: Ynt: Re: SQL Report with Quiz Questions and Answers for all Courses

by Ebin Manuval -

how can I get the quiz open time and close time ?

Average of ratings: -
In reply to Ebin Manuval

Ynt: Re: Ynt: Re: SQL Report with Quiz Questions and Answers for all Courses

by Uğur Feyzullahoğlu -

Hi,

Query below for exam start and end date

mdl_quiz_attempts columun -timestart-timefinish

SELECT mc.fullname , us.username , quiz.name, FROM_UNIXTIME(qa.timestart) ,FROM_UNIXTIME(qa.timefinish) , grade.grade

FROM mdl_quiz quiz, mdl_quiz_attempts qa, mdl_course mc, mdl_user us, mdl_quiz_grades grade

WHERE qa.quiz = grade.quiz

AND qa.userid = grade.userid

AND qa.quiz = quiz.id

AND qa.userid = us.id

AND us.id = grade.userid

AND quiz.course=mc.id

Average of ratings: Useful (2)