Who marked Solution for Topic

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

1 Like

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
3 Likes

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?

1 Like

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.

1 Like

You actually do :wink:

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

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

3 Likes