Has anyone come up with any badges based on some value for custom user fields? If so, how can we get at those custom user fields with a SQL query? Here’s a sample badge (there is surely better SQL to do this!) that we quickly hacked together to look for people who filled out an optional custom use…

[imagem] downey: Here’s a sample badge (there is surely better SQL to do this!) that we quickly hacked together to look for people who filled out an optional custom user field, in this example, to list their GitHub User ID: Awesome badge. Thank you for sharing this!

I :heartpulse: this - thanks for sharing! Works for me. One thing I noticed: it’s not immediately apparent on the custom user field which user_field_n goes which which user field and it doesn’t start at 1! I found it by looking at the source of that page. Do you know how to modify this query to di…

I think you’d simply add the following: AND EXISTS ( SELECT 1 FROM user_badges ib WHERE cf.user_id = ib.user_id AND ib.badge_id = 888 ) Where 888 is the badge ID number of the other prerequisite badge. See the following for details: [imagem] Badges predicated on gett…

[imagem] downey: Note that the value of name field is actually user_field_1, user_field_2, etc., and not the name that you’ve assigned in the admin section. Well the name given should be in a table somewhere, though joining on it to create a dynamically generated field name may not make the q…

[imagem] PJH: And you’ll have to be careful when editing (specifically adding and removing other) fields of course. Agreed. I’m hopeful to find an answer related to that here: [imagem] Unused TOS custom user field safe to delete? Support AFAIK, I a…

I had an issue with setting that to work on user edit or creation so I had to modify it a bit. If someone wants to do the same, you need to use the following code: SELECT cf.user_id user_id, cf.updated_at granted_at FROM user_custom_fields cf WHERE cf.name = 'user_field_2' AND ( cf.user_id IN (:u…

Is there a way to modify the above code so that the badge links to the post which granted the badge, similar to how “First Share” works? Also, if I set that badge to be allowed to be given more than once, will the above code do it for multiple posts in the same thread? If not, how could I do that? …

[imagem] db0: Is there a way to modify the above code so that the badge links to the post which granted the badge, similar to how “First Share” works? There is no post associated with filling out the custom fields, unless I’m missing something from your query. But in general, to associate po…

Gah, you’re right, sorry I referred the wrong code. I got the following SELECT DISTINCT ON (p.user_id) p.user_id, p.id post_id, p.created_at granted_at FROM badge_posts p WHERE p.topic_id = 110 AND (:backfill OR p.id IN (:post_ids) ) which I took from another tip in the thread. This automatical…

Yes, that query should be marked as targets posts, show post on the public badges page, and trigger on post creation.

Badges based on User Custom Fields?

Community Building Data & reporting

downey (Michael Downey) 22 Fevereiro , 2015 19:00 6

Agreed. I’m hopeful to find an answer related to that here:

Tópico		Respostas	Vistas
Trust level 0 + custom field badge Data & reporting sql-triggered-badge	1	801	20 Fevereiro , 2021
The default badge queries Data & reporting reference , sql-triggered-badge	1	979	27 Agosto , 2023
Creating custom badge with custom rules Data & reporting sql-triggered-badge	10	1722	14 Março , 2023
Numeric badge from external source in users profile Support	5	502	3 Novembro , 2021
What is the bug reporter badge? Data & reporting sql-triggered-badge	33	9664	17 Setembro , 2023

Badges based on User Custom Fields?

Related topics