Hi,
I'm using Questionnaire module with Moodle 3.1. I've a course with a lot of questionnaires- all are identical (that is same questions). i want to create a report which shows individual responses from all the questionnaires in a course. Could someone pelase help me with an SQL query for the same?
I want my output similar to the "Download in text format" option which is available against each questionnaire instance. But the difference is that, it should be for multiple questionnaires filtered with a course id or date range or something like that.
Questions include rating, text box and essay box types