A member of our Discourse forum has asked if Discourse has a way to show/recognize consecutive days visiting in or posting in a Discourse forum. I don’t see that information anywhere in the admin’s user information, is it kept anywhere? FWIW, reddit has this feature.

[Screenshot 2025-01-29 at 8.02.06 PM] You can probably make a data explorer query. here is the user_visits table schema here: app/models/user_visit.rb d75a0b116 # == Schema Information # # Table name: user_visits # # id :integer not null, primary key # user_id :integer not null # visited_at :date not null # posts_read :integer default(0) # mobile :boolean default(FALSE) # time_read :integer default(0), not null # # Indexes # # index_user_visits_on_user_id_and_visited_at (user_id,visited_at) UNIQUE # index_user_visits_on_user_id_and_visited_at_and_time_read (user_id,visited_at,time_read) # index_user_visits_on_visited_at_and_mobile (visited_at,mobile) # maybe something like this? :thinking: WITH consecutive_visits AS ( SELECT user_id, visited_at, visited_at - INTERVAL '1 day' * ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY visited_at) AS grp FROM user_visits ), visit_streaks AS ( SELECT user_id, COUNT(*) AS streak_length FROM consecutive_visits GROUP BY user_id, grp ) SELECT user_id, MAX(streak_length) AS longest_streak FROM visit_streaks GROUP BY user_id ORDER BY longest_streak DESC LIMIT 100 or perhaps you could combine with the user_actions table instead (visits with likes and posts?), which is here: app/models/user_action.rb d75a0b116 # Table name: user_actions # # id :integer not null, primary key # action_type :integer not null # user_id :integer not null # target_topic_id :integer # target_post_id :integer # target_user_id :integer # acting_user_id :integer # created_at :datetime not null # updated_at :datetime not null # # Indexes # # idx_unique_rows (action_type,user_id,target_topic_id,target_post_id,acting_user_id) UNIQUE # idx_user_actions_speed_up_user_all (user_id,created_at,action_type) # index_user_actions_on_acting_user_id (acting_user_id) # index_user_actions_on_action_type_and_created_at (action_type,created_at) # index_user_actions_on_target_post_id (target_post_id) # index_user_actions_on_target_user_id (target_user_id) WHERE (target_user_id IS NOT NULL) This file has been truncated. show original

Thanks, I’ll keep that in mind.

האם Discourse עוקב אחר ימים רצופים של פעילות?

קהילה נתונים ודיווח

NateDhaliwal (Nate Dhaliwal) 30 בינואר,‏ 2025,‏ 3:52am 2

Well, yes, as there are badges like Enthusiast, Aficionado, and Devotee that are for consecutive days visited. Visited = liked a post/replied once IIRC.

נושא		תגובות	צפיות
How can I see how many days in a row I visited the forum? Product Support	2	1838	25 באוקטובר,‏ 2018
See how many days straight we've been on the forums Feature	4	863	15 באוגוסט,‏ 2023
Is there a log of user visits? Product Support	6	1713	27 באוקטובר,‏ 2018
Daily usage streak and badges (for building a habit) Feature	8	1527	13 באוקטובר,‏ 2017
'Seen in last X days' badge? Data & reporting sql-triggered-badge	12	388	26 באוגוסט,‏ 2016

האם Discourse עוקב אחר ימים רצופים של פעילות?

נושאים קשורים