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

[изображение] 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 …

[изображение] 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 u…

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

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?

Создание сообщества Данные и отчетность

downey (Michael Downey) 22.Февраль.2015 19:00:31 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	794	20.02.2021
The default badge queries Data & reporting sql-triggered-badge , reference	1	923	27.08.2023
Creating custom badge with custom rules Data & reporting sql-triggered-badge	10	1671	14.03.2023
Numeric badge from external source in users profile Support	5	485	03.11.2021
What is the bug reporter badge? Data & reporting sql-triggered-badge	33	9567	17.09.2023

Badges based on User Custom Fields?

Связанные темы