How to get leaner progress from db in Open edX tutor

Development
1

how to get leaner progress from db in openedx tutor.

2

Hi @rahul.bhaskar,
I may not have understood your question correctly but the learner progress is shown in the progress bar.

Screenshot 2023-12-05 at 6.02.52 PM
Screenshot 2023-12-05 at 6.02.52 PM1902×1380 222 KB

3

I am looking to send learner progress through email in all friday’s untill they enrolled to the course.

4

There is a table in the mysql database that may be what you are looking for:

mysql> describe completion_blockcompletion;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| created    | datetime(6)  | NO   |     | NULL    |                |
| modified   | datetime(6)  | NO   |     | NULL    |                |
| id         | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| course_key | varchar(255) | NO   | MUL | NULL    |                |
| block_key  | varchar(255) | NO   |     | NULL    |                |
| block_type | varchar(64)  | NO   |     | NULL    |                |
| completion | double       | NO   |     | NULL    |                |
| user_id    | int(11)      | NO   | MUL | NULL    |                |
+------------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
5

Thank you very much

6

How can I get prcentage of completion of a user

7

What was the table where Instructor detais are saved for a course