Location of database table for quiz group mode?

Location of database table for quiz group mode?

by Erin Billy -
Number of replies: 2

I've looked at a bunch of the database tables for quiz an question (pasted below), but I can't find the table that stores whether a quiz is set to group mode.

Why? I want to change all quizzes we have to enable them to display in group mode rather than reset them one by one.

Using Moodle 3.0.3+ (Build: 20160426)

The database tables I looked at:

  • mdl_question_answers
  • mdl_question_attempts
  • mdl_question_attempt_steps
  • mdl_question_attempt_step_data
  • mdl_question_calculated
  • mdl_question_calculated_options
  • mdl_question_categories
  • mdl_question_datasets
  • mdl_question_dataset_definitions
  • mdl_question_dataset_items
  • mdl_question_ddwtos
  • mdl_question_gapselect
  • mdl_question_hints
  • mdl_question_multianswer
  • mdl_question_numerical
  • mdl_question_numerical_options
  • mdl_question_numerical_units
  • mdl_question_response_analysis
  • mdl_question_response_count
  • mdl_question_statistics
  • mdl_question_truefalse
  • mdl_question_usages
  • mdl_quiz
  • mdl_quiz_attempts
  • mdl_quiz_feedback
  • mdl_quiz_grades
  • mdl_quiz_overrides
  • mdl_quiz_overview_regrades
  • mdl_quiz_reports
  • mdl_quiz_sections
  • mdl_quiz_slots
  • mdl_quiz_statistics
Average of ratings: -
In reply to Erin Billy

Re: Location of database table for quiz group mode?

by Adam Olley -
Picture of Core developers Picture of Plugin developers

Hi Erin,

I believe you want the mdl_course_modules table.

If you already have the course module id, looking that up will be easy. Otherwise you'll need to join with the quiz table and modules table to pull up the correct course_module for your given quiz.

Average of ratings: Useful (1)
In reply to Adam Olley

Re: Location of database table for quiz group mode?

by Erin Billy -

Thanks so much, Adam. I'll take a look there.