Query to find out who marked the solution as solved

Support

AI 生成的摘要

wildrobo is trying to find out who marked a post as the solution. david suggests using Data Explorer queries, providing links to relevant topics with example queries. wildrobo tries the queries but doesn’t get any results for action_type = 15. david explains that logging for the “solved” event was only added to the plugin 6 months ago, so older events may not be accurate. wildrobo confirms that the topics involved are only a couple of days old, but suspects that their plugin version (“0.1”) may not include the necessary update to track the “solved” event.

1

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?

2

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

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.

4

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

5

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.