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:
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
ORDER BY created_at DESC
To produce a list with stats per-user: (with variable for time interval, defaults to 1 year):
-- string :interval = 1 year
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
Summary: The Discourse Solved plugin allows users to accept solutions on topics in designated categories.
Install: Follow the plugin installation guide.
Edit category you wish to enable accepted answers on:
As the OP (topic creator) you will have a button that allows you to accept an answer
Accepted answers are highlighted in the topic list:
Accepted answers are hig…
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 old are the “solved” events that you’re trying to analyse, it’s possible that you’ve hit this problem
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.