Reading Confirmations

[Lilly]

Hi @janns6023 welcome

I’m not sure what format or how much data you are looking for, but you can probably use data explorer for something like this.

Is it possible to see the topics a user has viewed?

Maybe something like: Who (logged in user) view specific topic -- [params] -- int :topic_id = 1 SELECT title, viewed_at, tv.user_id FROM topics t LEFT JOIN topic_views tv ON t.id = tv.topic_id WHERE category_id IS NOT NULL AND tv.user_id IS NOT NULL AND t.id = :topic_id ORDER BY viewed_at DESC LIMIT 1000 Last 100 topic view by user -- [params] -- int :user_id = 1 SELECT tv.user_id, title, viewed_at, views, t.user_id FROM topics t LEFT JOIN topic_vi…