In which table course instructor details are added in openedx database. I need to add a custom Instructor notification based on the leaner submission of open response.
They are stored in MongoDB, as “field values” for the course XBlock (code). They are not stored in a MySQL table as far as I know. It would be easiest to access them from python - get a reference to the course root block, then access course.instructor_info.
1 Like
No they are stored in mysql only. I found the table and using for my operations
Can you share what table that was, in case others are looking for the same thing?
And maybe I misunderstood what information you are looking for.
I was looking for the table that was storing Course instructor or staff role details table. I found that table in mysql db and table name is student_courseaccessrole
Ah, sorry - I totally misunderstood your question.
1 Like