General developer forum

Database query for Quiz results grades report

 
Picture of Joe Schmoe
Database query for Quiz results grades report
 

Can someone point me to the file or function that is used to generate data set for Quiz results grades report (see attached picure)?

I need to find a database query that is used for it.


 
Average of ratings: -
Tim at Lone Pine Koala Sanctuary
Re: Database query for Quiz results grades report
Core developersDocumentation writersParticularly helpful MoodlersPlugin developers

Well, the URL when accessing that page is mod/quiz/report.php, so that is a clue. That uses code from reportlib.php, and most of the query is built in base_sql in mod/quiz/report/attemptsreport_table.php, but the exact SQL depends on the options selected, so it is complicated.

 
Average of ratings: Useful (1)
Picture of Joe Schmoe
Re: Database query for Quiz results grades report
 

Thanks.

 
Average of ratings: -