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?
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
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.
Cheers
Ian
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.