SQL - Get a list of courses using default Grade Letters

SQL - Get a list of courses using default Grade Letters

by Sandeep Kankatala -
Number of replies: 0

Hi 

I am trying to get a list of courses that use default Grade Letters and have not overridden them grade letters.

I was able to write a query to get a list of courses that are overridden joining prefix_course, prefix_context and prefix_grade_letters.

I am unable to find out the relationship between sitelevel grade letter settings and contextid for the courses that are not overridden.

Any help is appreciated.

Thanks.

Average of ratings: -