Does anyone know where I can find unread messages?
I have a number of instances where the teacher can't find the one that isn't read. I should be able to find it for them, but I don't know what table shows whether these messages are read or not. I'm guessing it's in mdl_message_read.timeread = 0
But I'm not sure.