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…

[이미지] 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: [이미지] Badges predicated on getting…

[이미지] 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 quer…

[이미지] 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: [이미지] Unused TOS custom user field safe to delete? Support AFAIK, I am not …

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? …

[이미지] 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 posts…

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) 2월 22, 2015, 7:00오후 6

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

글		댓글	조회수
Trust level 0 + custom field badge Data & reporting sql-triggered-badge	1	811	2월 20, 2021
The default badge queries Data & reporting reference , sql-triggered-badge	1	1029	8월 27, 2023
Creating custom badge with custom rules Data & reporting sql-triggered-badge	10	1769	3월 14, 2023
Numeric badge from external source in users profile Support	5	515	11월 3, 2021
What is the bug reporter badge? Data & reporting sql-triggered-badge	33	9790	9월 17, 2023

Badges based on User Custom Fields?

Related topics