I see the “is_accepted_answer” name with the “true” value in the post_custom_fields. I also see the created_at and updated_at field but I am looking for something like an updated_by field. Where can I find out who marked the post as the solution?

There’s some queries you can put into data explorer here: [תמונה] How do I see who is marking solved and on what? Data & reporting I was interested to see these stats for my instance as well, so had a go at making some queries for data explorer: To list each individual “solved” event: SELECT acting_user_id, target_topic_id, target_post_id, created_at FROM user_actions WHERE action_type=15 ORDER BY created_at DESC To produce a list with stats per-user: (with variable for time interval, defaults to 1 year): -- [params] -- string :interval = 1 year SELECT ua.acting_user_id, count(case t.user_id when ua.acting_use… I’ve also just added them to the main discourse-solved topic, alongside the “badges” SQL queries [תמונה] Discourse Solved Plugin discourse2 Summary Discourse Solved lets topic authors and staff members mark a reply as the topic’s solution. open_book Install Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. While Discourse Solved can be used in a variety of use cases, this documentation is focused on the primary use case of a support or Q&A category. discourse2 Note: Discourse Solved is not available on the Free plan. Setting up a support cat…

How old are the “solved” events that you’re trying to analyse, it’s possible that you’ve hit this problem [תמונה]How do I see who is marking solved and on what? Since this logging was only added to the plugin 6 months ago, any data before that will have the “acting_user” set to the OP of the topic, regardless of who actually clicked the button. I think anything less than 6 months old should be correct.

Thanks. The topics involved and the “solved” events are only a couple of days old. I will check to see the versions. You have definitely given me things to check out. It looks like there is only 1 version “0.1” of the plugin and I appear to be on that version. My guess is the update with the “solved” event does not exist in what I am running.

Query to find out who marked the solution as solved

Product Support

wildrobo (Mark R) 14 ביולי,‏ 2017,‏ 8:56pm 3

Thanks for the super detailed response. I took a look and don’t have any results for action_type = 15. Is that the same as post_action_type? Looks like I have only 8.

נושא		תגובות	צפיות
How to know who opted the Solution Product Support solved	8	351	26 במרץ,‏ 2025
How do I see who is marking solved and on what? Data & reporting solved , sql-query	10	2620	3 במאי,‏ 2018
Who has marked a particular topic as Solved Data & reporting solved , sql-query	0	487	16 באפריל,‏ 2023
Viewing the user who marks the solution Product Support solved	5	525	27 באוגוסט,‏ 2026
How to get number of solutions per users using Data Explorer? Data & reporting sql-query	10	1836	3 בנובמבר,‏ 2020

Query to find out who marked the solution as solved

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