Is there a way to view and/or reset all of the local-machine specific or user-specific settings applied for my account for our shared SQL data source? I'd like to be able to selectively remove settings where they were applied.
Hi,
There is no way for now but this is definitively something we want to add for the next major release. WE plan to release the beta of RDM 9.0 in a month
David Hervieux
Hi,
I will reuse existing thread if I may, since it is the same issue: is it possible to bulk reset user/local specific settings (other than batch edit with same setting undone?)
Best regards,
Rok
Hello,
You should be able to see your list of user/local specific settings if you go in File > My Account Settings and go in "User specific settings list" or "local specific settings list". From there you can import/export or edit/delete them. Let us know if this works for you.
Regards,
Hubert Mireault
Hi,
problem is that we have a user who unintentinally made batch edit of "a few hundred" entries, first with user specific and afterwards local specific... In dialog that you are suggesting there is no multiple select. Batch edit with "anti" setting seems not to drop user/local specific settings...
Best regards,
Rok
Would this SQL sentence drop all user/local specific settings?
update UserAccount set ConnectionOverrides='' where Email = 'userprincipalname@domain.com'
BR,
Rok
Yes, with two small changes (see below):
Warning!
Like with any SQL statement please make sure you have a proper backup of your database.
The statement below has been tested but there are always risks involved when running manual SQL statements on a production database.
UPDATE dbo.UserAccount SET ConnectionOverrides = NULL, ConnectionOverridesCacheID = NULL WHERE Email = 'userprincipalname@domain.com';
We will add a feature request to be able to do this via the UI
Best regards,
Stéfane Lavergne
Hello,
We added the multiselect feature to both user and local specific settings, this will be available starting with version 2021.1.16.0.
Regards,
Jean-Francois Duchesne