# Query to find out who marked the solution as solved
**URL:** https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153
**Category:** Support
**Tags:** solved
**Created:** [2017 年7 月 13 日 19:50 UTC](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153 "2017-07-13T19:50:32Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@wildrobo](https://meta.discourse.org/u/wildrobo)
#### Post date: [2017 年7 月 13 日 19:50 UTC](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153/1 "2017-07-13T19:50:32Z")
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?
---
### Author:  [@david](https://meta.discourse.org/u/david)
#### Post date: [2017 年7 月 13 日 20:34 UTC](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153/2 "2017-07-13T20:34:06Z")
There’s some queries you can put into [data explorer](https://meta.discourse.org/t/data-explorer-plugin/32566) here:
> [@How do I see who is marking solved and on what?](https://meta.discourse.org/t/how-do-i-see-who-is-marking-solved-and-on-what/63981/4):
>
> I was interested to see these stats for my instance as well, so had a go at making some queries for [data explorer](https://meta.discourse.org/t/32566?silent=true): 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](https://meta.discourse.org/t/discourse-solved-accepted-answer-plugin/30155):
>
> discourse2Summary Discourse Solved allows users to accept solutions on topics in designated categories.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. Enabling Solved The Solved plugin can be enabled from its settings, accessed from your admin/plugins page: After enabling the plugin, to switch on Solved for all categories use the allow solved on all topics site setting. Alternati…
---
### Author:  [@wildrobo](https://meta.discourse.org/u/wildrobo)
#### Post date: [2017 年7 月 14 日 20:56 UTC](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153/3 "2017-07-14T20:56:58Z")
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.
---
### Author:  [@david](https://meta.discourse.org/u/david)
#### Post date: [2017 年7 月 15 日 00:11 UTC](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153/4 "2017-07-15T00:11:58Z")
How old are the “solved” events that you’re trying to analyse, it’s possible that you’ve hit this problem
> [@How do I see who is marking solved and on what?](https://meta.discourse.org/t/how-do-i-see-who-is-marking-solved-and-on-what/63981/4):
>
> 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.
---
### Author:  [@wildrobo](https://meta.discourse.org/u/wildrobo)
#### Post date: [2017 年7 月 17 日 17:10 UTC](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153/5 "2017-07-17T17:10:24Z")
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.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [2020 年9 月 22 日 11:09 UTC](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153/6 "2020-09-22T11:09:09Z")