How to update Watched First Post Categories for all users?

[BaronGrivet]

I’ve been looking at this topic as a way of updating the “Watching First Post” field for all the users:

Edit a user setting for all Discourse users

So you want to edit user setting for all Discourse users? Great, let’s get started! From console, run this command: ./launcher enter app Access Rails console: rails c From Rails console, run the query: To set the last seen date for users who have never logged in (never seen): User.where("last_seen_at IS NULL").update_all(last_seen_at: 1.week.ago) To default all users to mailing list mode (send an email for every new post): UserOption.update_all(mailing_list_mode: true) To default all u…

However I can’t work out which model/ column to change. This does not work:

UserOption.update_all(watched_first_post_category_ids: '[5,6,7,8]')

As watched_first_post_category_ids does not exist in the user_options table.

I’ve had a poke around in the Discourse Github code but I’m new to Rails & not sure what I should be looking for.

Could someone please give me the correct Rails Console command to change the “Watching First Post” field for all users?

[codinghorror (Jeff Atwood)]

@tshenry can you advise?

[pfaffman (Jay Pfaffman)]

I’m on my phone and can’t test but I think just remove the quotes from around the array.

[tshenry (Taylor)]

This should be what you are looking for

How do I set category tracking level defaults historically

Following the release of Discourse v2.4.0.beta7 (or if you have this commit), admins now have the option to set the category tracking levels of all existing users when setting the default category tracking levels in their site settings: Add a category to one of the following site settings, then select the green checkbox button. [10%20PM] A modal window will pop up with the following options: [10%20PM]

The old way using the console

Discourse allows you to specify default…