We are allowing our Trust Level 3 customers to mark Solved, but we have no good way to see how many they are doing. For example, see if a small number of this group are actually doing this work. I did see [이미지] See who marked post as solved? Feature Is there …

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 …

I have this bookmarked it is quite easy to add a query to data explorer

[이미지] david: – [params] – string :interval = 1 year SELECT ua.user_id, count(case t.user_id when ua.user_id then 1 else null end) as is_op, count(case t.user_id when ua.user_id then null else 1 end) as not_op, count(*) as total FROM user_actions ua LEFT JOIN topics t ON target_topic_id =…

Yep, you’re quite right. I just updated my post with a corrected query. Also note the cavet I put at the bottom

[이미지] david: SELECT acting_user_id, target_topic_id, target_post_id, created_at FROM user_actions WHERE action_type=15 ORDER BY created_at DESC Any way to make this show the user that marked it solved? It shows the user that solved it and their post, very useful. It would be nice to see who…

[이미지] david: SELECT acting_user_id, target_topic_id, target_post_id, created_at FROM user_actions WHERE action_type=15 ORDER BY created_at DESC So sneaky! Looks great!!

So looking at this, if I read this correctly, “is_op” means their post has been marked as a solution to a topic? I am building a Monthly Leaderboard query and want to add those who’ve had posts marked as solutions to topics.

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

커뮤니티 구축 데이터 및 보고

david (David Taylor) 6월 6, 2017, 12:01오전 9

I did another sneaky edit there just now, if you copy/paste it again then it should work as intended - let me know if not!

I really should test things better before posting

글		댓글	조회수
Query to find out who marked the solution as solved Support solved	4	3264	7월 17, 2017
How to know who opted the Solution Support solved	8	317	3월 26, 2025
Who has marked a particular topic as Solved Data & reporting solved , sql-query	0	479	4월 16, 2023
How to get number of solutions per users using Data Explorer? Data & reporting sql-query	10	1800	11월 3, 2020
Viewing the user who marks the solution Support solved	5	473	8월 27, 2026

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

Related topics