Hello
How to reset all users preferences?
I mean I can go to admin->user management-> reset user preferences
But what if I do some crucial or not changes and wanna all users can see those updates immediately?
For example cases, I faced just now
I modify the Global Search Module list - enable some module and those modules will appear as ‘disable module’
Every user should manually enable it
I think it will be good if will be a way to manually rest all users preferences at on click (SuiteCRM can be stored more 100 users…)
This will copy one user’s saved search for all other users:
And here’s some SQL I just developed to “multiply” a saved_search from one user to all users.
Backup your table before you begin, handling SQL directly can sometimes be deadly to your data…
INSERT INTO `saved_search`
(
`id`, `name`, `search_module`, `deleted`, `date_entered`, `date_modified`, `assigned_user_id`, `contents`, `description`
)
SELECT
CAST(FLOOR(RAND()*10000000) AS char(36)) `id`,
`name`, `search_module`, `saved_search`.`deleted`, `saved_search`.`date_entered`, …
This one is a more elegant code-based solution for the same:
https://www.ciconet.it/en/soluzioni/182-predefined-searches-in-sugarcrm-ce-65-or-suitecrm.php
This is not exactly what you need, but you can get insights from that: the user preferences are base64-encoded in the same way, only they are found in the user_preferences table.