Anyone able to provide the query for all users with a custom title (not a badge granted title)?

I don’t think this is strictly possible, because a custom title could be character-by-character identical to a badge granted one (possible of a badge the user doesn’t have). Here’s a query that might do what you want: SELECT username FROM users WHERE title IS NOT NULL AND ( SELECT count(*) FROM badges WHERE allow_title = true AND name = title ) = 0 AND ( SELECT count(*) FROM groups WHERE groups.title = users.title ) = 0 It selects every title any user has, minus every title where a corresponding badge exists, minus every title that could come from a group membership. It does not test whether the user has the badge or the group membership. Maybe it does help you, at least as a starting point :slight_smile:

Thanks @fefrei, that seems to work, but as you mentioned it might not cover all the edge cases. I did have to change the first line SELECT title FROM users to SELECT username FROM users as I was looking for the usernames, not the custom titles. @Mittineague was able to create a query that seems to work as well SELECT users.username , users.title FROM users JOIN user_profiles ON user_profiles.user_id = users.id WHERE users.title IS NOT NULL AND users.title NOT LIKE '' AND user_profiles.badge_granted_title IS NOT TRUE

[imagem] jomaxro: I did have to change the first line SELECT title FROM users to SELECT username FROM users as I was looking for the usernames, not the custom titles. Oops, I forgot to copy the query again after fixing that :blush: [imagem] jomaxro: @Mittineague was able to create a query that seems to work as well in this topic. That query looks better – I didn’t find the badge_granted_title flag. I’m not sure how this query handles titles granted by group membership, though.

[imagem] fefrei: I’m not sure how this query handles titles granted by group membership, though. Nor am I. However, this accomplishes our goal. For some background: we currently don’t have any badge_granted_titles available to users, as we have no custom badges, the only titles are regular and leader, and we’ve “disabled” TL3. We have granted titles in the past to exceptional community members. The community started asking about titles, so the mod team started discussing options. One thing that was agreed upon is that we wanted the custom titles to stand out from the “everyday” badge_granted_titles. To apply CSS to them, we needed to add all the users to a group, hence the request for a query to select them.

A query for users with a custom title?

Community Building Data & reporting

fefrei (Felix Freiberger) Outubro 15, 2016, 6:04pm 4

Oops, I forgot to copy the query again after fixing that

That query looks better – I didn’t find the badge_granted_title flag. I’m not sure how this query handles titles granted by group membership, though.

Tópico		Respostas	Visualizações
Let users custom their title Feature	13	6090	29 de Março de 2016
How are user titles generated? Product Support	13	7604	28 de Fevereiro de 2017
How to show registered users the ability to add title Product Support	1	1636	10 de Setembro de 2016
Additional CSS class for user-title? Feature	1	854	15 de Dezembro de 2022
Creating dynamic titles using groups or badges? Product Support	3	182	30 de Abril de 2025

A query for users with a custom title?

Tópicos relacionados