Creating a new view for user results

Oh I see. It appears after looking in the code these views (the default quiz views) are the only ones capable of taking on this information.

Would it not be beneficial to provide all of the quiz items as handlers? That is... quiz questions, quiz results etc etc.

Also, I do not understand the Views API enough to fix this... but it looks like we have a bug involving quiz_views_handler_argument_quiz_nid.

I am getting error messages when trying to use this relationship...
Column not found: 1054 Unknown column 'quiz_node_relationship.vid' in 'on clause'

The class found in this file is completely empty. It looks like the node_relationship table got rid of this and replaced it with parent_vid?

Ok, I have fixed up quiz.views.inc to be compadible with the new structure. A lot of the references did not account for vid > parent_vid and child_vid and nid > parent_nid and child_nid.

This is now fixed, however, I have one issue left. I will post up a patch once I am done.

Now the issue I am experiencing is that I cannot relate result answers to a specific result ID. When pulling the results answers it is pulling all answers, instead of those specific to the result ID being queried.

This stems from the views query builder doing this following:

LEFT JOIN {quiz_node_results_answers} quiz_node_results_answers ON quiz_node_relationship.child_nid = quiz_node_results_answers.question_nid

This actually needs to be:
LEFT JOIN {quiz_node_results_answers} quiz_node_results_answers ON quiz_node_relationship.child_nid = quiz_node_results_answers.question_nid AND quiz_node_results_answers.result_id = quiz_node_results.result_id

Right now when adding the field 'Result ID' or 'Is Correct' it does not allow me to add a relationship. What needs to be configured in the quiz.views.inc to make this happen? I tried specifying the following under 'is_correct', but it doesn't seem to be doing it.

     'relationship' => array(
        'handler' => 'views_handler_relationship',
        'base' => 'quiz_node_results',
        'field' => 'result_id',
        'base field' => 'result_id',
        'label' => t('Result'),
      ),

Ok, I have finally dug in farther into this. Is there ever an instance where you would want the quiz_node_results_answers table to not include the link between the quiz_node_results.results_id table?

I added in the following to the quiz_node_results_answers table definition in views. I have also attached the patch to all o the updates made to 7.x-5.x views branch. This updates a lot of the structure updates that involved nid being changed to parent_nid and child_nid, and vid being changed to parent_vid and child_vid.

$data['quiz_node_results_answers'] = array(
    // Table Definition
    'table' => array(
      'group' => 'Quiz Results by Question',

      'join' => array(
        'quiz_node_properties' => array(
          'left_table' => 'quiz_node_relationship',
          'left_field' => 'child_nid',
          'field' => 'question_nid',
          'extra' => 'quiz_node_results_answers.result_id = quiz_node_results.result_id'
        ),
      ),
    ),

This patch also includes the patch applied @ #842958: quiz_node_results join to node

^^

Rerolled against 7.x-4.x

Cleared bug, re-rolled patch. Also I introduced a lot of unneeded spaces in the previous patch. Cleaned those up.

Hi edboost,

I'm glad I could help out others and that what I did didn't introduce too many bugs :) I'm not sure how I managed that, but you are correct, the line went missing from my updates. After realizing that I was updating my dev server, while viewing my staging site and screaming to myself, why in the world is this not updating!!!... all is well in the world again. :) Patch updated, re-rolled against 7-x-4.x-dev.

~ mpearrow, does the patch not apply to the release you want? This would only be the case if something has changed along the way.

~mukwenhac, this can be done with a template.

Make sure -show feedback at the end of a quiz is checked under the taking options.
I believe the template you are looking for, and can place in your templates directory, is 'quiz-take-summary.tpl.php'.