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 preference for everyone or a subset of users

If you need to update the user preference for all of your users or a large subset of users, you can do so via the rails console. From console, run these commands to enter the rails console for Discourse ./launcher enter app rails c Then, run a command that selects the set of users you wish to update. Examples Set the last seen date for users who have never logged in User.where("last_seen_at IS NULL").update_all(last_seen_at: 1.week.ago) Unset mailing list mode for all users who may have se…

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

(Obsolete) 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…