Where in DB are Grade Category percentages stored?

Re: Where in DB are Grade Category percentages stored?

by Perry Way -
Number of replies: 1

Ah ha! I am answering my own question. Hahah! I tend to do that sort of thing. Anyone else have that "problem"? smile

I started digging into the code for the Moodle form for the category settings when you edit it, and quickly I was able to see the percentage I'm looking for is the value found in the `grademax` column in {grade_items} but how the item record is joined to the {grade_category} is a little nebulous at the moment to me. I'm sure I will answer this in another 10 minutes. It is a different sort of master-child relationship because the `categoryid` column is null. I'm thinking the join occurs with the `iteminstance` column, and will know after lunch today I'm sure.

In reply to Perry Way

Re: Where in DB are Grade Category percentages stored?

by Richard van Iwaarden -
Picture of Particularly helpful Moodlers

Hope I'm not bothering your months-long lunch, but have you found the solution yet smile

I need to know where the category information is stored in the DB, looking for the average & grade to pass information.