Query to find out who marked the solution as solved

[wildrobo (Mark R)]

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?

[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…

[wildrobo (Mark R)]

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.

[david (David Taylor)]

How old are the “solved” events that you’re trying to analyse, it’s possible that you’ve hit this problem

@david

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.

[wildrobo (Mark R)]

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.