
- This event has passed.
Run % SQL
May 14 @ 4:00 pm - 5:00 pm CDT
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)
If you need any disability-related accommodation to fully participate in this event, please contact University Events at events@augsburg.edu. Please allow for sufficient time to arrange the accommodation.