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.