Use code to change theme

(0) Share

Report

Posted on by Yuji

4,131

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,

I have the same question (0)

All responses (10)

Answers (2)

Martin Dráb 237,926 Most Valuable Professional on at

Like (0)

Report

What value did you set to the field?

Did you reload the application or called appl.setTheme()?

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

Hi Martin,

I just set the theme value to 0.

Thanks,

Was this reply helpful? Yes No
Martin Dráb 237,926 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,926 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

Do you think you could share your code with us? It would help us identify potential issues in it.

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

update SYSUSERINFO set THEME =0

Was this reply helpful? Yes No
André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

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.

Thanks,

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No