Hi, I am using the following query to check accepted solutions this month. However, I do not see data past March. Additionally, these numbers do not match what is shown on the Accepted solutions Report. Could I get some guidance here on what I’m doing wrong? SELECT DISTINCT YEAR(p.created_at), MON…

Hi Shreyas, Looking at the query you’ve shared, the reason you’re not seeing data past March and that the numbers in your query don’t match the Accepted Solutions Dashboard Report is because you’re using the posts_custom_fields database table, however, the Discourse Solved plugin tracks accepted so…

Thank you @SaraDev ! This is helpful. I will check the output of this query once I am able to get discourse_solved_solved_topics in Snowflake to query.

已接受解决方案查询

社区数据与报告

Shreyas_Kulkarni (Shreyas Kulkarni) 2025年七月3日 18:14 3

谢谢@SaraDev！这很有帮助。我将检查此查询的输出，一旦我能够在 Snowflake 中查询 discourse_solved_solved_topics。

話題		回覆	觀看
Dashboard Report - Accepted Solutions Data & reporting solved , sql-query , dashboard-reports , dashboard-sql	0	636	2023年十二月15日
Find posts "solved" in specific month Data & reporting solved , sql-query	4	1634	2019年三月29日
Query to find out who marked the solution as solved Support solved	4	3246	2017年七月17日
How to find solved topics in db Support solved , sql-query	1	128	2025年四月30日
Topics solved by staff (lists topics) Data & reporting solved , sql-query	0	207	2018年二月12日

已接受解决方案查询

相關主題