See who viewed topic

社区 数据与报告
1

Is there a way to see all users that viewed a topic? Just curious who is viewing and not replying.

if there is a way, can it be locked to a certain security group?

2 个赞
2

This data is in the database but there is no UI to view it.

1 个赞
3

This could be a nice item for the admin/wrench menu some day…

2 个赞
4

Since this is not an ability to use via the UI. Should this topic be moved over to the suggestions category?

Thanks for replying, awesome support. Very much appreciate everyone here. Its crazy how awesome support is compared to all other companies, this is what sets Discourse apart from others on top of the forum itself. great , great, great!!!

2 个赞
5

We are looking at this for personal messages, specifically, where staff can check to see who has seen important messages.

7 个赞
6

I see there’s be no message traffic on this post for some time. And, there is still no ability to see who has viewed posts. I can understand why this might be a bit unwieldy is lots of people viewed a particular topic, but if the list was small, it would be good a moderator to be able to see who looked and did nothing more. IMHO.

7

I don’t know how much work, if any, has gone into making this a feature. But if you use the Data Explorer plugin you can query the topic_users table to find out who has seen a topic. Maybe JOIN with the posts table to see who has visited the topic and who has posted a reply in it?

8

Hi，Jeff，
Someway，how can we see what topic some user have viewed？
thank you

9

Yes, you can do this with the Data Explorer Plugin; which means, only staff can do it.

4 个赞
10

thanks，it helps me。:smiley:

11

我有一个用于此目的的数据探索器查询（该查询显示用户名以启用 CSV/群组/私信等功能）：

-- 谁查看了此主题？https://meta.discourse.org/t/see-who-viewed-topic/29277/11
-- [params]
-- int :topic_id
SELECT tu.user_id, u.username, total_msecs_viewed/1000 AS seconds_viewed
FROM topic_users tu
JOIN users u ON tu.user_id  = u.id
WHERE tu.topic_id = :topic_id
    AND total_msecs_viewed > 0
GROUP BY tu.user_id, u.username, tu.total_msecs_viewed
ORDER BY tu.total_msecs_viewed desc

如果在你所处的上下文中公开电子邮件地址是可以接受的，那么我建议使用以下这个查询：

-- 谁查看了此主题？包含电子邮件。https://meta.discourse.org/t/see-who-viewed-topic/29277/11
-- [params]
-- int :topic_id
SELECT tu.user_id, email, total_msecs_viewed/1000 AS seconds_viewed
FROM topic_users tu
JOIN user_emails ue ON tu.user_id  = ue.user_id
WHERE tu.topic_id = :topic_id
    AND total_msecs_viewed > 0
GROUP BY tu.user_id, ue.email, tu.total_msecs_viewed
ORDER BY tu.total_msecs_viewed desc
1 个赞