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 [תמונה] 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 user_id column…

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:

סטטיסטיקות על שימוש בנושאים

תמיכה

Falco (Falco) 16 בדצמבר,‏ 2022,‏ 9:23pm 3

See also

נושא		תגובות	צפיות
Data Explorer - Query to determine user theme preferences Data & reporting sql-query	5	858	18 בינואר,‏ 2019
Is there any way of telling how popular a Theme is? Data & reporting sql-query	5	985	1 בספטמבר,‏ 2018
How can I tell which Discourse theme is in use? Support	2	631	10 בדצמבר,‏ 2020
Themes and Associated Theme Components Report Data & reporting sql-query	0	53	21 באוקטובר,‏ 2025
Previously selected user themes can override allowed themes Support	16	1365	2 באוקטובר,‏ 2022

סטטיסטיקות על שימוש בנושאים

נושאים קשורים