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 Plugin … 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 stack…

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…

Qui a marqué la solution pour le sujet

Soutien

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

Tu le fais en réalité

La réponse de Michael est correcte, il suffit de l’activer :

Sujet		Réponses	Vues
Viewing the user who marks the solution Support solved	4	323	Avril 19, 2024
How do I see who is marking solved and on what? Data & reporting solved , sql-query	11	2429	Juin 8, 2024
How to know who opted the Solution Support solved	9	148	Mars 26, 2025
How to get number of solutions per users using Data Explorer? Data & reporting sql-query	10	1700	Novembre 3, 2020
Query to find out who marked the solution as solved Support solved	5	3140	Septembre 22, 2020

Qui a marqué la solution pour le sujet

Sujets connexes