Visualisation de l'utilisateur qui marque la solution

[Moin]

Vous pouvez utiliser l’explorateur de données pour le découvrir

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…