I realize this is an oddball request but is it possible, perhaps via a data explorer query, to retrieve a full list of posts in a specific category that has been read by a specific user? Is it possible to create a list of topics and posts a user has seen generally? This might be interesting. My story is that we have a private category which admins are not supposed to be reading. Everyone knows and can live with the fact that we have to have access to it for admin purposes but the understanding is that we mute the category in our prefs and do not actively go seek out messages in that category. Knowing that there’s a paper trail will help us to resist the temptation to do that. :slight_smile:

SELECT tu.topic_id, tu.last_read_post_number FROM topics LEFT OUTER JOIN topic_users AS tu ON topics.id = tu.topic_id WHERE topics.category_id = 4 AND tu.user_id = 1 AND tu.last_visited_at IS NOT NULL I guess this is what you are looking for.

Interesting use case - fairly unique I should imagine Just from a practical point of view I am not sure it would help since the admin could simply impersonate a valid user and read it that way? Or maybe go into Anonymous mode (if you allow that). Would it be easier to set it up as a group so they can PM each other instead? Not sure what rights admins have to private messages

I think admin actions like impersonation are logged. Anonymous mode wouldn’t work because it’s a private category only accessible to a particular group (plus admins). Admins can also read PMs - they have access to everything. In any case, we prefer categories and topics to messages. I’m not really too worried about all this and don’t want to create draconian or big brother-esque oversight of admins, but thought it would be worthwhile to have a way - even if it’s hard to do - to check in case there is ever a concern.

that worked! many thanks. :seedling:

Is it possible to get a list of topics in a category read by a specific user?

Community Building Data & reporting

tobiaseigen (Tobias Eigen) 26 Abril , 2017 17:44 5

that worked! many thanks.

Tópico		Respostas	Vistas
Read history for a particular category Data & reporting sql-query	2	442	11 Maio , 2022
Find users who read specific topics Data & reporting sql-query	9	2173	30 Outubro , 2018
Reading Confirmations Feature	3	258	12 Novembro , 2024
Users who have accessed a topic in a protected category Data & reporting sql-query	3	192	15 Março , 2019
Data explorer query - new topics for user by tag/category Data & reporting sql-query	2	838	25 Janeiro , 2022

Is it possible to get a list of topics in a category read by a specific user?

Related topics