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.

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

Data & reporting

JammyDodger Split this topic May 11, 2022, 10:23am 6

3 posts were split to a new topic: Read history for a particular category

Topic		Replies	Views
Read history for a particular category Data & reporting sql-query	3	363	May 11, 2022
Is it possible to see the topics a user has viewed? Data & reporting sql-query	3	1660	June 21, 2020
How to track which users viewed a particular topic? Feature	6	1627	August 18, 2020
Feature Request: Make user topic mutes log available to admins Feature	0	279	April 4, 2023
Can Admins see all Deleted PMs? Support	9	1802	June 8, 2024

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

Related Topics