Community Sentiment en Toxiciteit queries

[SaraDev (Sara Devlaeminck)]

Adding this one here as well:

Dashboard Report - Post Emotion

This is an SQL version of the Dashboard Report for Post Emotion. This report requires the Discourse AI plugin and Sentiment Analysis to be enabled. This dashboard report shows the number of posts classified with one of following emotions, group by poster trust level, within a specified date range: Sadness Surprise Fear Anger Joy Disgust -- [params] -- date :start_date = 2024-01-16 -- date :end_date = 2024-02-16 -- int :threshold = 30 SELECT u.trust_level AS trust_level, …