Change course completion settings from database

Change course completion settings from database

by Dulitha Rajapaksha -
Number of replies: 1

There are some courses which has setup the course completion as "Course is complete when ANY of the conditions are met". And I need to change that to "Course is complete when ALL of the conditions are met" from the database without affecting the students grades.

If I change that from the DB level, which tables should I change to take effect? I have the course IDs with me so I need to make a query which can be executed in the DB.

I need to know in which tables should I change the values to facilitate above.


PS - I am mentioning about this option. There is a drop down after I unlock this.

Average of ratings: -
In reply to Dulitha Rajapaksha

Re: Change course completion settings from database

by studyingroup com -
I think it's in "course_completion_aggr_methd"
https://github.com/moodle/moodle/blob/87afa4d7595eeafdf9e3f83d53272ee61fb66780/completion/completion_aggregation.php#L43

because this class 'completion_aggregation' is indeed called by the form
https://github.com/moodle/moodle/blob/87afa4d7595eeafdf9e3f83d53272ee61fb66780/course/completion_form.php#L67

...where this is defined:
https://github.com/moodle/moodle/blob/58ba94a7290940391d1581e591a64fc7e6bb410a/lang/en/completion.php#L184
...
$string['overallaggregation_any'] = 'Course is complete when ANY of the conditions are met';
...
Average of ratings: -