How to know who opted the Solution

[Moin]

You can use the data explorer plugin to find out

Who has marked a particular topic as Solved

To look up who has marked a particular topic as Solved: -- [params] -- topic_id :topic_id SELECT target_topic_id, acting_user_id, created_at::date FROM user_actions WHERE target_topic_id = :topic_id AND action_type = 15 ORDER BY created_at DESC

How do I see who is marking solved and on what?

I was interested to see these stats for my instance as well, so had a go at making some queries for data explorer: To list each individual “solved” event: SELECT acting_user_id, target_topic_id, target_post_id, created_at FROM user_actions WHERE action_type=15 ORDER BY created_at DESC To produce a list with stats per-user: (with variable for time interval, defaults to 1 year): -- [params] -- string :interval = 1 year SELECT ua.acting_user_id, count(case t.user_id when ua.acting_use…

There’s also this open #feature request you may find interesting and want to add your voice to:

Display the user who marked the answer as correct

Over and over again I have wished I could tell who marked a post the solution: whether it was the OP or someone who (for whatever reason) wanted to close the topic