Wondering if anyone can help me with this.
I’m trying to determine how many users are using either the dark or light themes, I’ve cobbled this together for the Data Explorer;
/* light theme */ SELECT COUNT(*) FROM user_options WHERE theme_ids = 6
From what I can tell the ID of the theme is stored in the field
theme_ids and in array element 1, could anyone confirm this?
In our set up the dark theme appears as a value of 7, and the light theme a value of 6.
However, when I run the queries I get 140 people using dark, 32 using light. As we have several thousand users this seems a bit out so I’m guessing my cobbled together query is either wrong - or - are these values only stored for users that have specifically set a theme, where-as if they are just using the default this data isn’t stored?
Any info would be really appreciated.