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.

Consulta de Soluções Aceitas

Comunidade Dados e relatórios

Shreyas_Kulkarni (Shreyas Kulkarni) Julho 3, 2025, 6:14pm 3

Obrigado @SaraDev! Isso é útil. Vou verificar a saída desta consulta assim que conseguir obter discourse_solved_solved_topics no Snowflake para consultar.

Tópico		Respostas	Visualizações
Dashboard Report - Accepted Solutions Data & reporting solved , sql-query , dashboard-reports , dashboard-sql	0	610	15 de Dezembro de 2023
Find posts "solved" in specific month Data & reporting solved , sql-query	4	1607	29 de Março de 2019
Query to find out who marked the solution as solved Support solved	4	3184	17 de Julho de 2017
How to find solved topics in db Support solved , sql-query	1	112	30 de Abril de 2025
Topics solved by staff (lists topics) Data & reporting solved , sql-query	0	186	12 de Fevereiro de 2018

Consulta de Soluções Aceitas

Tópicos relacionados