Is there a simple way for an Admin to see who has Marked Post as Solution?

There isn’t a simple way for an admin to see who has marked a post as the solution, but the information is available in the database. It can be retrieved with a Data Explorer query. Here is a basic query that does that: --[params] -- int :topic_id SELECT acting_user_id FROM user_actions WHERE acti…

We have a Hosted Discourse, so dont think we have Data Explorer . Can this ability to see who has marked Solution for Topic be added to base line Discourse?

[image] ianm: Hosted Discourse, so dont think we have Data Explorer . If you are on the Business tier or above, you have access to it. It may need to be enabled in your admin panel first.

You actually do :wink: Michael response is correct, you just have to enable it: [image] Discourse Data Explorer … head to /admin/plugins . [de1] Click on the “Settings” button, and turn on data explorer enabled , then return and reload the page. There should now be a tab in the stacked nav c…

Thank you, Simon and team I have data explorer enabled and have created the query: `–[params] – int :topic_id SELECT acting_user_id FROM user_actions WHERE action_type = 15 AND target_topic_id = :topic_id` Presume I need to be pointing to topic, but how then do I run the query? Ah it seems I n…

Who marked Solution for Topic

Support

osioke (Osioke Itseuwa) June 30, 2021, 12:26pm 5

You actually do

Michael response is correct, you just have to enable it:

Topic		Replies	Views
Viewing the user who marks the solution Support solved	4	343	April 19, 2024
How do I see who is marking solved and on what? Data & reporting solved , sql-query	10	2437	May 3, 2018
How to know who opted the Solution Support solved	8	197	March 26, 2025
How to get number of solutions per users using Data Explorer? Data & reporting sql-query	10	1708	November 3, 2020
Query to find out who marked the solution as solved Support solved	4	3154	July 17, 2017

Who marked Solution for Topic

Related topics