On my forum I created multiple themes (with different colour schemes and features). I liked the customisation :wink: After a few years, I am now doing a refresh. I want to eliminate the old themes that are poorly utilised and consolidate on just 3 or 4. Is there any easy way of determining whic…

See also [immagine] Is there any way of telling how popular a Theme is? Data & reporting You don’t really need to look at the users table here to display usernames. Data Explorer will automatically display avatars and username if the result of your query has a…

Here’s my best answer before my battery dies: UserOption.where("theme_ids is not null").pluck(:theme_ids) Better would be to search for where that array is longer than 0, but I don’t know how to do that. This will get you all of them. You can then do something clever to sort and count.

Brillant. Thank you goes ! :slight_smile:

Statistiche sull'utilizzo dei temi

Supporto

Falco (Falco) 16 Dicembre 2022, 9:23pm 3

Vedi anche

Argomento		Risposte	Visualizzazioni
Data Explorer - Query to determine user theme preferences Data & reporting sql-query	4	865	Gennaio 16, 2019
Is there any way of telling how popular a Theme is? Data & reporting sql-query	4	994	Agosto 2, 2018
How can I tell which Discourse theme is in use? Support	1	634	Novembre 10, 2020
Themes and Associated Theme Components Report Data & reporting sql-query	0	60	Ottobre 21, 2025
Previously selected user themes can override allowed themes Support	15	1377	Maggio 19, 2019

Statistiche sull'utilizzo dei temi

Argomenti correlati