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: [изображение] How do I see who is marking solved and on what? Data & reporting 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…

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

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 “s…

Query to find out who marked the solution as solved

Support

wildrobo (Mark R) 14.Июль.2017 20:56:58 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.

Тема		Ответов	Просм.
How to know who opted the Solution Support solved	8	316	26.03.2025
How do I see who is marking solved and on what? Data & reporting solved , sql-query	10	2561	03.05.2018
Who has marked a particular topic as Solved Data & reporting solved , sql-query	0	479	16.04.2023
Viewing the user who marks the solution Support solved	5	462	27.08.2026
How to get number of solutions per users using Data Explorer? Data & reporting sql-query	10	1797	03.11.2020

Query to find out who marked the solution as solved

Связанные темы