I'm trying to archive really old messages and notifications that users haven't marked as read, but are still popping up when we call the message API through web services... somehow, these notifications and messages do NOT show up in the notification bell (nor does it show "unread" notifications on the user dashboard... only though the web services).
From what I understand, I have to insert the userid and the messageid (id field of mdl_notifications or mdl_messages) in the mdl_message_user_actions table. I believe the right action id would be "1", but I cannot find any documentation related to this... I've tried looking for a table that would give me the values linked to this number, but no luck (mdl_actions / mdl_user_actions do not exist).
Am I on the right path ? Has anyone done this before ?
What are the possible values for the "action" field in mdl_message_user_actions ?
Thanks in advance for anyone that can help me a little bit.