Course Report SQL Query

Course Report SQL Query

by Phillip Brough -
Number of replies: 4
Hi,

I need to produce an SQL query to report to another system all of the Questions and Answers for a User in a course. Information needs to have the student name, the questions and the students answers reported, the grade for each quiz, and the over all course grade.

The system I need to report too will also need the SQL query to show a User Grade Table, as per the normal moodle interface.

I am afraid that my SQL knowledge does not quite go that far.

Thanks in advance
Phil
In reply to Phillip Brough

Re: Course Report SQL Query

by Gavin Tomlins -
Good evening Phil,

did you get anywhere with your query.

If not, contact us, and I will get our team to give you some assistance to contribute back to the greater community.

Regards

Gavin
In reply to Phillip Brough

Re: Course Report SQL Query

by Richard Trout -
I was looking for the same function, needing detailed per user information on responses to quizzes or other moodle functions that post results (including SCORM).

I can't seem to find anyway to get this type of detailed information in moodle - how do others do it?
In reply to Phillip Brough

Re: Course Report SQL Query

by Jean FRUITET -
I use Outcomes to grade activities in Moodle and use a non standard module
Referentiel / Repository
(See http://moodle.org/mod/data/view.php?d=13&rid=2488&filter=1)
to get all that outcomes in a sort of portfolio.

All the source code to manage grades and outcomes is in
YOUR_MOODLE/mod/referentiel/grade/
directory.