Creating a view of type quiz, with row style as node, instead of fields.

Ok, so I've had some progress. I decided to try and modify the quiz.views.inc file to try and expose the answer fields from the multichoice question type. (Find code below).

I think I have the implementation correct, and the relationship of quiz_multichoice_answers table to quiz_node_relationship is also correct. But somehow it doesn't work. However, if I change the join for quiz_multichoice_answers to quiz_node_properties along with relevant changes to the 'left_field', instead of the above stated quiz_node_relationship, I can at least see the group and the fields listing in views UI. However nothing gets returned and the query that is run makes no sense.

Currently, with the following code, there are no fields or the group available in views. Any ideas?

  $data['quiz_multichoice_answers'] = array(
    'table' => array(
      'group' => t('Quiz Questions Answers'),
      'join' => array(
        // This is vid because vid is always more specific. We never work with
        // nid.
        'quiz_node_relationship' => array(
          'left_field' => 'child_vid',
          'field' => 'question_vid',
          'type' => 'INNER',
        ),
      ),
    ),
    //field defs
    'question_vid' => array(
      'title' => t('Quiz Question Node ID'),
      'help' => t('The node id of the quiz question to which the answer is attached.'),
      'field' => array(
        'handler' => 'views_handler_field_numeric',
        'click sortable' => TRUE,
      ),
      'sort' => array(
        'handler' => 'views_handler_sort',
      ),
    ),
    
    'answer' => array(
      'title' => t('Quiz Question Answer'),
      'help' => t('The answer attached to the question node.'),
      'field' => array(
        'handler' => 'views_handler_field',
        'click sortable' => TRUE,
      ),
      'sort' => array('handler' => 'views_handler_sort'),
    ), 
  );

I added the above to the quiz.views.inc just before the return $data line.

I just found two other issues that are more or less related. Just thought I'd mention it.

http://drupal.org/node/451302#comment-1551482
and
http://drupal.org/node/1115476