From Eric:
this should be run at the start of each semester
this displays real(percentage) for course total only, not every grade
Finished testing on Moodle 2019 for course display settings – all looks good. I’ll switch the display setting for all grades in Moodle 2020 then deploy.
For documentation, here is a select statement to show how many items will change:
SELECT
gi.id, gi.courseid, gi.iteminstance, gi.itemtype, gi.display
FROM mdl_grade_items as gi
WHERE
gi.itemtype = ‘course’
AND gi.display IN (0, 1, 3)
Then here is the update statement I am using:
UPDATE mdl_grade_items
SET display = CASE
WHEN display IN (0,1) THEN 12
WHEN display = 3 THEN 32
ELSE display
END
WHERE itemtype = ‘course’
AND display IN (0,1,3)