SQL Report for Quizes

SQL Report for Quizes

by Arkadiusz Baryła -
Number of replies: 2

Hello,

I'm trying to create SQL report, that displays all quizes in all courses with grades for users. Something like that

Firstname | lastname | course | quiz_name | quiz_score | date_modified/date_score|

Does someone have created a similar report. I could use a helping hand.

Average of ratings: -
In reply to Arkadiusz Baryła

Re: SQL Report for Quizes

by Randy Thornton -
Picture of Documentation writers

You'll find an entire section of Quiz reports over the Ad-hoc queries page: https://docs.moodle.org/32/en/ad-hoc_contributed_reports#Quiz_Module_Reports

Average of ratings: -
In reply to Randy Thornton

Odp: Re: SQL Report for Quizes

by Arkadiusz Baryła -

Yes,
I've seen this page earlier, but none of these queries does not meet my expectations.

I analyzed all of these queries.

Average of ratings: -