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) 3 ביולי,‏ 2025,‏ 6:14pm 3

תודה @SaraDev! זה מועיל. אבדוק את הפלט של השאילתה הזו ברגע שאוכל לקבל את discourse_solved_solved_topics ב-Snowflake כדי לבצע שאילתה.

נושא		תגובות	צפיות
Dashboard Report - Accepted Solutions Data & reporting solved , sql-query , dashboard-reports , dashboard-sql	0	590	15 בדצמבר,‏ 2023
Find posts "solved" in specific month Data & reporting solved , sql-query	4	1598	29 במרץ,‏ 2019
Query to find out who marked the solution as solved Support solved	4	3161	17 ביולי,‏ 2017
How to find solved topics in db Support solved , sql-query	1	94	30 באפריל,‏ 2025
Topics solved by staff (lists topics) Data & reporting solved , sql-query	0	179	12 בפברואר,‏ 2018

שאילת פתרונות מקובלים

נושאים קשורים