Visual notification for unread messages in a topic

Hello everyone !

Here’s just a quick update that might be useful to someone else. I finally succeeded, and indeed it was “quite complex” for a beginner like me.

The hardest part was creating the query that retrieves the information on the last visit of a subject, to then compare it to the date of the last message posted and return to “unread” if this is the case.

In the same query I also counted the “unread” subjects for each category to return the categories to “notify”.

I share this request if it can help someone later…

It was difficult, but I learned a lot. Thanks for the initial help!