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) 7월 3, 2025, 6:14오후 3

@SaraDev님, 감사합니다! 정말 도움이 됩니다. Snowflake에서 discourse_solved_solved_topics를 쿼리할 수 있게 되면 해당 쿼리의 출력을 확인해 보겠습니다.

글		댓글	조회수
Dashboard Report - Accepted Solutions Data & reporting solved , sql-query , dashboard-reports , dashboard-sql	0	620	12월 15, 2023
Find posts "solved" in specific month Data & reporting solved , sql-query	4	1618	3월 29, 2019
Query to find out who marked the solution as solved Support solved	4	3210	7월 17, 2017
How to find solved topics in db Support solved , sql-query	1	123	4월 30, 2025
Topics solved by staff (lists topics) Data & reporting solved , sql-query	0	195	2월 12, 2018

수락된 솔루션 쿼리

Related topics