Where do System Settings data get saved?

[Mussie]

Hi Guys,

Does anybody know where these details are saved? Thought they are stored in sys_user_preference but apparently they are not.

Regards,

Mussie

[Alikutty A]

Hi Mussie,

These are saved under user preferences. In order to find its related user preference, you can update these values for your profile and check in the user preferences table sorted by updated column and user="Your Id"

I just changed its values and it got captured in my user preference.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[Alikutty A]

Hi Mussie,

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list. If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

https://community.servicenow.com/docs/DOC-5601

Thank You

Please Hit like, Helpful or Correct depending on the impact of the response

[Mussie]

Thanks Alikutty, appreciate your reply. Yes, they are getting stored in sys_user_preference. However, that doesn't solve my original issue. Here is what I wanted, when users change their language settings, I want everything to be updated according to the chosen language. I can't do this from the Portal page as there is no settings button there. Is there any way I can achieve this? The only thing I could think of was to include the Language field from the sys_user table under profile and have them select the language.

But this is not triggering the response I wanted. I also have written a BR that inserts a record in the sys_user_preference after the language field is updated in the sys_user table but this is not triggering the language change I am after even after the page is reloaded.

Anything you can think of to achieve this?

Mussie

[Alikutty A · Accepted solution]

Are you trying to add a language selector for service portal? There is oob language picker widget available for the same.

Once user changes the language using system settings, it applies to all of the instance translations.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response