SQL query to change activity completion tracking in multiple instances

SQL query to change activity completion tracking in multiple instances

by Matt Bury -
Number of replies: 0
Picture of Plugin developers

Hi Moodlers,

I'm trying to change all instances of a Moodle module with SQL, e.g.:

  • From: Label > Activity completion = Students can manually mark the activity as completed
  • To: Label > Activity completion = Do not indicate activity completion

I'm not sure where I can find these settings in the Moodle database. I'd like to run a SQL query like:

UPDATE `mdl_[tablename]` SET `[columnname]` = '[value]' WHERE `mdl_[tablename]`.`course` = 4

...but I suspect it's not that simple.

Thanks in advance,

Matt smile

Average of ratings: -