Affects Version/s: 1.9.7
Component/s: Module: Questionnaire
Environment:Moodle : Fedora 10, Apache-2.2, PHP-5.2
Database : Microsoft SQL
Fixed Branches:MOODLE_19_STABLE, MOODLE_20_STABLE
The "View All Responses" in Questionnaire Report fails to retrieve the responses of type text, bool, date and single from the MS-SQL database.
This is mainly due to the issue in using fields of type text in GROUP BY clause. The following methods in questiontypes/questiontypes.class.php are affected by this bug:
Steps to reproduce:
1. Create a questionnaire with question type "text box", "drop box" and "date"
2. Login as student and attempt the questionnaire
3. Login again as administrator/teacher and click on "All Responses" tab in the Questionnaire.
All responses should list all the questions with their responses
The responses of "text box", "date", and "drop box type " are not displayed.