Since I update my Discourse to ver 3.5.0.beta3-dev my query for searching solved topics does not work proper anymore. To find solved topic I usually querying table topic_custom_fields for column name to contains accepted_answer_post_id select users.username,count(distinct assignments.topic_id) obaveza from assignments inner join users on assignments.assigned_to_id=users.id inner join topics on assignments.topic_id=topics.id inner join categories on topics.category_id=categories.id left outer join topic_custom_fields on topics.id=topic_custom_fields.topic_id and topic_custom_fields.name='accepted_answer_post_id' where assignments.active=true and assigned_to_type='User' and deleted_at is null and topics.closed=false and topic_custom_fields.value is null group by users.username order by obaveza desc But now looks like table topic_custom_fields do not get row with accepted_answer_post_id value. Where I should look now for solved/unsolved topics ? Here is my json query { "query": { "id": 12, "name": "Broj obaveza po krosniuku gurpisano", "description": "Ovo je broj obaveza po korisku grupisan", "username": "admir", "group_ids": [47], "last_run_at": "2025-04-30T13:07:43.405Z", "user_id": 5, "sql": "\r\n\r\nselect \r\nusers.username,count(distinct assignments.topic_id) obaveza\r\nfrom assignments\r\ninner join users on assignments.assigned_to_id=users.id\r\ninner join topics on assignments.topic_id=topics.id\r\ninner join categories on topics.category_id=categories.id\r\nleft outer join topic_custom_fields on topics.id=topic_custom_fields.topic_id and topic_custom_fields.name='accepted_answer_post_id'\r\nwhere assignments.active=true\r\nand assigned_to_type='User'\r\nand deleted_at is null\r\nand topics.closed=false\r\nand topic_custom_fields.value is null\r\ngroup by users.username\r\norder by obaveza desc", "param_info": [], "created_at": "2023-08-29T13:15:17.015Z", "hidden": false } }

How to find solved topics in db

adopilot (Admir Hodzic) April 30, 2025, 1:27pm 3

My apologies for opening topic, I find needed data it inside table discourse_solved_solved_topics it is little tricky to browse all 250 tables inside catalog.

Topic		Replies	Views
Who has marked a particular topic as Solved Data & reporting solved , sql-query	0	486	April 16, 2023
Query to find out who marked the solution as solved Product Support solved	4	3307	July 17, 2017
Where is Solved data stored in the database? Product Support solved	4	728	February 9, 2024
Topics stats of Solved/Unsolved topics, inc. 'time to solution' Data & reporting solved , sql-query	0	262	April 22, 2023
How to know who opted the Solution Product Support solved	8	346	March 26, 2025

How to find solved topics in db

Related topics