SQL Query Question

SQL Query Question

by Amir Elion -
Number of replies: 1
I got not response for this on Gradebook forum so I thought I'd tap into the developers' knowledge...

I have installed Custom SQL reports plug-in: http://docs.moodle.org/en/Custom_SQL_queries_report
Would appreciate help in defining a query for finding/displaying all activity grades of all students in a certain course category. Moodle version is 1.9.5+ (Build: 20090624)

Also - is there a description of the database tables structure somewhere for future query reference?

Thanks,

Amir
Average of ratings: -
In reply to Amir Elion

Re: SQL Query Question

by David Mudrák -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators
Hi Amir,

I am not sure the Custom SQL will be enough to get gradebook data in an useful way. There is more logic behing grades processing in Moodle.

IMO what you want is to write your own gradebook report. See the current standard reports for the reference.

d.