conversation_messages.context_type only has Account?

[IanGoh]

I was investigating if I can find out if a student messaged a course teacher.

When I looked at our CD2 conversation_messages table, all the context_type seems to be Account.

I could work backwards a bit, e.g.,

1) find all the student's courses

2) find the teachers for the courses

3) find messages where only the student, teacher participated.

But then I lose some data.  If the teacher happens to be teaching more than one course that the student is enrolled in, I cannot tell what course it pertains.

Is there any other way to figure out course context for the conversation_message that I'm missing?

Thanks!

Ian

[pgo586 · Accepted solution]

While I haven't really looked carefully at the data in these tables yet, I see there is also the 'conversations' table, which is linked to 'conversation_messages'. It appears that the conversations table *does* have different values of 'context_type', one of which is 'Course'., aside from 'Account' and 'Group'. So in theory, perhaps you could use this table to keep track of the course the conversation is in (just an idea).

[IanGoh]

Thanks!  I took a quick peek at the one conversation_message I knew was between the student and teacher, traced back the conversation_id -> conversations.id and did indeed find that it have a context_type: course.