Hi everybody,
Maybe you can help me, because I'm quite new to the SQL subject.
I've installed the configurable reports plugin to make a report of what my students did on one quiz in a specific course. Moodle doesn't give me the opportunity do do exactly what I want so I thought I needed the configurable reports plugin.
I want to make a report containing the following items:
Course shortname,
User firstname,
User lastname,
Quizname,
Questionnumber,
Questionname,
Questiontext,
Result for this quiz
I figured that I need to build a custom SQL report to do so. Can anyone help me to make the report as I want it?
Thanks a lot!