Where the chosen answer is saved in mysql table ? [#2882035]

Where the chosen answer of user is save during session the quiz..?
Quiz progress module use table quiz_node_results_answers in mysql to implement their module which is have answer_id,is_correct,is_doubtful,is_skipped etc but not available for the answer chosen option..
so where the exact table in mysql to know during the session of quiz the user chose A,B or C option in every question...??
we only know it when the user done their quiz in result views, i really want to create contrib module for it but still confused..!:(

Cheers..!

here is the screenshot :)

Comment	File	Size	Author
#4	unbk.png	90.85 KB	imunklovarian

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

29 May 2017 at 05:37

imunklovarian created an issue. See original summary.

Comment #2

djdevin

Philadelphia

CreditAttribution: djdevin at Cadmium commented 6 June 2017 at 13:30

Category:

Plan

» Support request

Each question module stores its own answers. We don't know what the answer data will look like, so we let the questions decide.

The base question response entity "quiz_result_answer" (which is the quiz_node_results_answers table in the database) stores the base fields for the question that are required - things like correctness, skipped, points, etc.

But for example a short answer question stores text in an additional table while a multiple choice question stores selected options. Short answer only has 1 table, but multiple choice needs 3 tables to handle all the options for answer storage.

So if you were to build your own custom question module, you would provide the storage for your answers.

Hope that helps

Comment #3

imunklovarian CreditAttribution: imunklovarian commented 18 June 2017 at 06:12

Done..! i have created a custom module to store option answer in that is chosen by user in quiz progress so the user will know what they have chosen A,B or C in every question by seeing the quiz progress list here the screenshot
http://i67.tinypic.com/34rg0mq.png

thanks a lot dude..!