SQL report for cohort enrolled in course (or competency of same name) with their actual_score, required_score and the gap (moodle 3.5))

SQL report for cohort enrolled in course (or competency of same name) with their actual_score, required_score and the gap (moodle 3.5))

by Kashyap Kr -
Number of replies: 0

  1. SQL report for cohort enrolled in course (or competency of same name) with their actual_score, required_score and the gap.
  2. I made a table called mdl_competency_gap with id, cohort_id, course_name, and required_score.
  3. I tried SQL ad hoc report in configurable reports plugins. 

              

Average of ratings: -