Am I completely misunderstanding entirely what these values are for?
I’ve been using Data Explorer to review activity and noted that topic_users.last_visited_at
didn’t seem to be updating / showing topics I have recently visited.
Is topic_users.last_visited_at
supposed to be updated on every visit to a topic?
Here is the Query I was using with Data Explorer.
-- [params]
-- int :user_id = 1
SELECT
topic_id,
last_visited_at,
first_visited_at
from topic_users
WHERE
user_id = :user_id
ORDER BY
topic_users.last_visited_at DESC
When this is executed I see NULL’s for topics I have visited and even some I have created:
Scrolling down further to get to some dates I see:
Where I have visited each of these topics today 2016-04-07, however it looks like only the first visit was stamped.
So are last_visited_at
and first_visited_at
updated correctly - or am I just misunderstanding entirely what these values are for?
Is there a timestamp that’s updated when a user visits a topic?