Question about modifying notification settings for all existing users

Hello,

I would like to be able to change the activity notification settings for all registered users. Via the web interface, it is only possible to change the setting for users who will be added after the change (new users).
Is it possible to do this afterwards for users already registered, for example by directly modifying records in the database?

I guess my query is too specific for anyone to have looked into it yet.
In the meantime I saw that the table to be modified was _preferences and that rows of this type should be added for each user(or modified but by default the entries are non-existent, which should be equivalent to configvalue = 0)

image

I just have to find the right SQL command to create/update the needed rows for each user. If I do, I‘ll share it there, in case someone may need it.

1 Like