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?

البيانات والتقارير

JammyDodger قسَّم هذا الموضوع في 11 مايو 2022، 10:23ص 6

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

الموضوع		الردود	مرات العرض
Read history for a particular category Data & reporting sql-query	3	370	11 مايو 2022
Find users who read specific topics Data & reporting sql-query	10	1811	29 نوفمبر 2018
Reading Confirmations Feature	3	71	12 نوفمبر 2024
Users who have accessed a topic in a protected category Data & reporting sql-query	3	129	15 مارس 2019
Data explorer query - new topics for user by tag/category Data & reporting sql-query	2	755	25 يناير 2022

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

الموضوعات ذات الصلة