Notifications
Announcements
Hi,
I tried to update sysuserinfo.theme value to change the user theme (the default color of the system). However even though I change the theme value, but the system still show the original color.
Any idea?
Thanks,
What value did you set to the field?
Did you reload the application or called appl.setTheme()?
Hi Martin,
I just set the theme value to 0.
What color do you expect to get by using 0?
Also, you missed my other question. If it means that you didn't do either thing, that it's expected that nothing will happen.
0 seems to be a valid value, although you should use the enum: SysUserInfoTheme::Theme0.
Note that it will make no difference if the current value is Theme0 too.
Do you think you could share your code with us? It would help us identify potential issues in it.
update SYSUSERINFO set THEME =0
Hi Yuji,
You shared an SQL statement, so I do assume this is not related to a production environment?
What color(s) are selected now and which color do you want to apply?
Please remember that if you update data via direct SQL (in a system where it's possible), you bypass AOS caching, so the AOS might still use an outdated value for the user.
If the AOS has SysUserInfo record cached, and it doesn't know that it's updated, it will not make a database call if a session requests that record. But if you update the value via x++, AOS knows that the cached version is outdated and will discard it.
Hi André,
Yes, we just want to change all testing environment to use the default theme (0). But it seems even we ran this script in SQL, it did not change the user's default color.
If you make direct SQL updates in a test system, make sure that the AOS is not running during the update. Otherwise you will have cache issues.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 622 Super User 2025 Season 2
Abhilash Warrier 438 Super User 2025 Season 2
Martin Dráb 354 Most Valuable Professional
