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 action_type = 15 AND target_topic_id = :topic_id

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?

[תמונה] 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: [תמונה]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 called “Data Explorer”. Select it or head to /admin/plugins/explorer , then use the + , Import or Run Query buttons to get started.

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 need to copy the topic_id into the prompted window. :wink: Cheers Ian

מי סימן פתרון לנושא

תמיכה

osioke (Osioke Itseuwa) 30 ביוני,‏ 2021,‏ 12:26pm 5

You actually do

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

נושא		תגובות	צפיות
How do I see who is marking solved and on what? Data & reporting solved , sql-query	10	2620	3 במאי,‏ 2018
Viewing the user who marks the solution Product Support solved	5	525	27 באוגוסט,‏ 2026
How to know who opted the Solution Product Support solved	8	351	26 במרץ,‏ 2025
How to get number of solutions per users using Data Explorer? Data & reporting sql-query	10	1836	3 בנובמבר,‏ 2020
Query to find out who marked the solution as solved Product Support solved	4	3310	17 ביולי,‏ 2017

מי סימן פתרון לנושא

נושאים קשורים