Query to find out who marked the solution as solved

[david (David Taylor)]

There’s some queries you can put into data explorer here:

How do I see who is marking solved and on what?

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

Summary Discourse Solved allows users to accept solutions on topics in designated categories. Repository Link https://github.com/discourse/discourse-solved Install Guide How to install plugins in Discourse Enabling Solved The Solved plugin can be enabled from its settings, accessed from your admin/plugins page: [admin/plugins] After enabling the plugin, to switch on Solved for all categories use the allow solved on all topics sit…