Making a query to retrieve a user’s grades for each course

  • Resolved theomega1123

    (@theomega1123)


    1 year, 3 months ago

    Hello!

    I’m trying to display a list of all the grades for each course achieved by the user.

    I’d like to know the name of the db table in wich this data is stored, so I can make a query and display the information in the frontend. I’d like to develop a shortcode wich gets the current user’s ID, to get a list of the user’s enrolled courses and the grades for this course.

    In case this isnt possible, I could use ACF to make a ‘student’s final grade’ field, but I’ would’ll need to know where to assign this field so I can retrieve this value later.

    Any information on this topic, specially regarding db tables, is greatly appreciated.

    Best wishes!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Deric (a11n)

    (@dericleeyy)

    Sensei LMS stores the grades as comments. I’ll recommend looking at sensei/includes/class-sensei-grading.php as it contains multiple examples of how the grades are retrieved and calculated.

    For example, check out the function for get_course_users_grades_sum.

    Plugin Support Tamirat B. (a11n)

    (@tamirat22)

    It’s been one week since this topic was last updated. I’m going to mark this thread as solved. If you have any further questions or need more help, you’re welcome to open another thread here. Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Making a query to retrieve a user’s grades for each course’ is closed to new replies.