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) 03.Июль.2025 18:14:18 3

Спасибо, @SaraDev! Это полезно. Я проверю результат этого запроса, как только смогу получить discourse_solved_solved_topics в Snowflake для выполнения запроса.

Тема		Ответов	Просм.
Dashboard Report - Accepted Solutions Data & reporting dashboard-reports , sql-query , dashboard-sql , solved	0	572	15.12.2023
Find posts "solved" in specific month Data & reporting solved , sql-query	4	1572	29.03.2019
Query to find out who marked the solution as solved Support solved	5	3148	22.09.2020
How to find solved topics in db Support solved , sql-query	2	70	30.04.2025
Topics solved by staff (lists topics) Data & reporting sql-query , solved	0	171	12.02.2018

Запрос принятых решений

Связанные темы