General developer forum

Useful SQL Queries?

Picture of alain kerv
Re: Useful SQL Queries?

I use the "questionnaire" activity since moodle version 2.5. Today, I switched to moodle 3.2 and the process has not changed !)
When the end of the semester comes, I have to go through each questionnaire, download the result to a csv file and format it. (300 courses, a questionnaire / course)
That's crazy.
My question is: Is it possible to extract the results directly from the database via a SQL query? Probably yes, but I would know the tables involved.
Has anyone been affected by this problem ? If so, do you have any information to communicate to advance on the subject?

Average of ratings: -