해결책으로 표시한 사용자 보기

[Moin]

데이터 탐색기를 사용하면 그걸 확인할 수 있습니다.

특정 주제를 '해결됨'으로 표시한 사람은 누구인가요?

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…