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 a…

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 = …

[图片] 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 …

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! :wink: I really should test things better before posting :laughing:

[图片] 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) 2017 年6 月 5 日 23:52 6

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

话题		回复	浏览量
Query to find out who marked the solution as solved Support solved	4	3264	2017 年7 月 17 日
How to know who opted the Solution Support solved	8	317	2025 年3 月 26 日
Who has marked a particular topic as Solved Data & reporting solved , sql-query	0	479	2023 年4 月 16 日
How to get number of solutions per users using Data Explorer? Data & reporting sql-query	10	1800	2020 年11 月 3 日
Viewing the user who marks the solution Support solved	5	473	2026 年8 月 27 日

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

相关话题