Query to find out who marked the solution as solved

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’ve also just added them to the main discourse-solved topic, alongside the “badges” SQL queries

2 Likes

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

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.