Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.I'm afraid this is still against the 7.x-4.x version as there's no 7.x-1.x version to download.
The attached patch just extends the quiz views integration and adds in the following features:
- Exposes the max_score column in the quiz_node_properties table to views so it can be used as a field, an argument and in sorting - handy for creating alternative admin views listing, or for calculating the percentage score using Views' new Global: math field.
- Adds in a filter on result_id in quiz_node_results table so you can filter the results to match a particular result set.
- Exposes all of the quiz_node_results_answers table so you can generate detailed reports of the answers given for each result set.
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | 1294588.patch | 14.54 KB | stella |
| #4 | 1294588.patch | 13.02 KB | stella |
| #3 | 1294588.patch | 9.51 KB | stella |
| #1 | 1294588.patch | 6.54 KB | stella |
| additional_views_integration.patch | 6.25 KB | stella | |
Comments
Comment #1
stella CreditAttribution: stella commentedOh an updated version which now also exposes the "weight" column in the "quiz_node_relationship" table as a field and a sort to views.
Comment #2
Sivaji_Ganesh_Jojodae CreditAttribution: Sivaji_Ganesh_Jojodae commentedstella, thanks for your patch. Could you please provide your views export, I would like to add that to quiz default views.
Regarding the 7.x-1.x branch, you could download it from version control tab for now http://drupal.org/node/26481/git-instructions/7.x-1.x
Comment #3
stella CreditAttribution: stella commentedPatch re-roll which exposes some of the fields in the quiz_multichoice_answers table as well as the other changes already outlined. Really it'd be great if all fields in all of the quiz module tables would be exposed to Views. I'm kinda just focusing on the ones I need :(
Some of the views I'm working on rely on a custom table I created - mainly cos I couldn't figure out a way to show a user's first and most recent results for each quiz, one row per quiz. So I have a custom table where I store that information when a quiz is completed. It was just easier. I'll have a look at the others though and send you anything generic enough. I can also send you a link to the site when it goes live if you want.
Comment #4
stella CreditAttribution: stella commentedPatch re-roll which now also includes exposing quiz_multichoice_user_answers table to views.
Comment #5
stella CreditAttribution: stella commentedAnd another version which adds in exposure of quiz_multichoice_user_answer_multi table to views. Think this is the last one!! :)
Comment #6
Sivaji_Ganesh_Jojodae CreditAttribution: Sivaji_Ganesh_Jojodae commentedStella thanks again for your patches. I just committed the patch #5 to quiz (without much testing). I thought a view export would be great to do it but I understand that your view counts on custom tables. I have created a separate issue #1301142: Add more default views for testing views integration and adding more usable default views to quiz.
Comment #12
Poieo CreditAttribution: Poieo commentedBased on the issue description:
It would appear that the ability to create a view that displays actual answers for quiz results is possible in 7.x-4.x and 7.x-5x but I can't seem to figure it out specifically in 7.x-5.x. Is there a default view or help text that could point me in the right direction?