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

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 …

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

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.Апрель.2017 17:44:57 5

that worked! many thanks.

Тема		Ответов	Просм.
Read history for a particular category Data & reporting sql-query	2	426	11.05.2022
Find users who read specific topics Data & reporting sql-query	9	2063	30.10.2018
Reading Confirmations Feature	3	211	12.11.2024
Users who have accessed a topic in a protected category Data & reporting sql-query	3	175	15.03.2019
Data explorer query - new topics for user by tag/category Data & reporting sql-query	2	825	25.01.2022

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

Связанные темы