For those wondering how to view the classification results database for the Community Sentiment and Toxicity modules, this can be done using the Data Explorer plugin, and the classification_results table. This is useful for seeing how the AI plugin is functioning on your site and classifying posts. …

Is there a way to add a filter to this query to get the posts from a particular thread? Right now, it seems it is getting posts across the entire Community, which is nice, but also cumbersome to find a particular post/thread you are looking for, not to mention you will run into the row limit for th…

Hi @Samantha_O :wave: Does this work for specific topics? you will have to specify the topic ID in the params. -- [params] -- int :topic_id = SELECT cr.target_id as post_id, cr.model_used, cr.classification->'negative' as negative, cr.classification->'neutral' as neutral, cr.classification->'pos…

-- [params] -- topic_id :topic_id SELECT cr.target_id as post_id, cr.model_used, cr.classification->'negative' as negative, cr.classification->'neutral' as neutral, cr.classification->'positive' as positive FROM classification_results cr JOIN posts p ON p.id = cr.target_id WH…

I think this should target category id: -- [params] -- int :category_id = SELECT cr.target_id as post_id, cr.model_used, cr.classification->'negative' as negative, cr.classification->'neutral' as neutral, cr.classification->'positive' as positive FROM classification_results cr JOIN posts p ON p.i…

Thank you both! When I run these, it doesn’t find older topics/topic ids. I wonder - does the sentiment analysis only happen on new posts? edited for clarity

@JammyDodger would know better, but yes I think the sentiment analysis works on new posts. I think in order to get it to use the old posts would likely require some rails commands to process them through the sentiment model, and into the classification_results table (where the new posts’ analyses…

It works on new posts once it’s turned on. :+1: I’m not sure if there is a backfill option for it?

Only new posts from now. We can consider backfilling that information after we start reporting on the data and we validate it.

Would one of you (or another brilliant query-ist) be able to help me fine-tune this a bit? I would like to have params for dates and those dates would correspond to the post date. The end goal here would be to be able to look at changes over time while waiting to see if the dashboard can do that in…

Hi Samantha, If you wanted to refine those queries to include start and end date parameters, you could use a query like this: -- [params] -- date :start_date = 2023-01-01 -- date :end_date = 2024-01-01 SELECT p.created_at, cr.target_id as post_id, cr.model_used, cr.classification->'negative' as …

社区情绪与有害内容查询

社区数据与报告

Falco (Falco) 2024 年11 月 13 日 16:26 16

我已经更新了指南 Dashboard Report - Overall Sentiment 和 https://meta.discourse.org/t/dashboard-report-post-emotion/295553，你能用更新后的查询再试一次吗？

话题		回复	浏览量
AI sentiment and emotion analysis reports Data & reporting ai , sql-query , ai-sentiment	0	215	2025 年7 月 15 日
Dashboard Report - Overall Sentiment Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	2	857	2025 年7 月 3 日
Dashboard Report - Post Emotion Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	0	521	2024 年2 月 16 日
Adding visuals to Sentiment Analysis Feature ai , ai-sentiment	14	907	2023 年12 月 15 日
Classification in the Discourse Sentiment Dashboard Support ai , ai-sentiment	8	239	2026 年6 月 25 日

社区情绪与有害内容查询

相关话题