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) 2021 年6 月 30 日 12:26 5

你确实可以

Michael 的回复是正确的，你只需启用它：

话题		回复	浏览量
How do I see who is marking solved and on what? Data & reporting solved , sql-query	10	2615	2018 年5 月 3 日
Viewing the user who marks the solution Product Support solved	5	516	2026 年8 月 27 日
How to know who opted the Solution Product Support solved	8	340	2025 年3 月 26 日
How to get number of solutions per users using Data Explorer? Data & reporting sql-query	10	1832	2020 年11 月 3 日
Query to find out who marked the solution as solved Product Support solved	4	3299	2017 年7 月 17 日

谁标记了主题的解决方案

相关话题