We’ve created a bronze badge, Users Helping Users , for people trying to help other users. That’s granted manually (in order to tell the difference between attempts at being helpful and "me too"s). For each 5 bronze badges, we want to award a sliver, Invaluable , badge. The SQL I’ve come up with fin…

For posterity: after a direct look, @JammyDodger pointed out that Query targets posts had somehow become unchecked. That seems to have done it. He forced the job to run & :drum: … two silvers were granted! :tada: I’m setting this up on my production site & the preview tells me I should see 12 silve…

[이미지] G Ann Campbell: Also, it’s really not clear to me how the math happens so that my two users don’t get new badges every day (this will run on a nightly trigger) even if they haven’t gotten 5 new bronze badges. Unless you tick ‘Can be granted multiple times’ then it shouldn’t be awarded …

I did check ‘multiple times’ [Selection_1402] but it was only granted once, even though it should have been twice [Selection_1404]

So… what do I have to do to get my user with 12 bronze badges awarded the 2 silvers he deserves?

That is a good question that I don’t immediately know the answer to. :slight_smile: I’m tentatively thinking something using RANK but I may be clutching at straws… :thinking: ▶ Rough prototype... Okay, a second attempt using ROW_NUMBER instead: WITH badge_count AS ( SELECT user_id,…

Well… I gave my user another 4 bronzes yesterday to see if the overnight run would at least add the new badge he’d just “earned”. (I figured if I had to catch up the rest of them by hand, I could.) But even that didn’t work. [Selection_1418]

I can’t help you with the query, but suggest you ask the Discourse AI bot for help - select the bot icon in the top [image] → GPT-4 → SQL Helper. I’ve found it very good in creating data explorer queries from just telling it what I need and guess it can help with badge queries.

Not everyone has that, Toni :shushing_face: You’ll make people jealous. :slight_smile: (though @ganncamp does, so it is an option) But… I’m pretty sure my query is sound. It picks out the right ones in the Preview, but just doesn’t award more than one when using the ‘Update Daily’ trigger. [02c29…

I have access to it @tpetrov but my attempts to use it have been… less than fruitful. Or maybe I just excel at asking hard questions? :laughing:

[이미지] JammyDodger: Though, on further testing, this works correctly in the preview but isn’t being granted multiple times when the actual badge grant job runs. I’m not really sure why though. :thinking: After a little exploration and consultation, it seems that the auto badge granter will onl…

브론즈 배지 5개마다 은색 배지 1개씩

커뮤니티 구축 데이터 및 보고

ganncamp (G Ann Campbell) 10월 26, 2023, 6:53오후 2

Okay, deeper searching led me to a trail that landed me at the guide

The backfill thing is still a bit muddy, but I’ve decided to (duh!) trial this on our test instance. I suppose backfill runs overnight, so I’ll know more tomorrow.

글		댓글	조회수
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1074	3월 18, 2022
Awarding badges multiple times with custom SQL Data & reporting sql-triggered-badge	2	1222	10월 25, 2017
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	302	1월 17, 2024
SQL Querying in Badges Data & reporting sql-triggered-badge	1	1072	12월 4, 2015
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	707	5월 23, 2023

브론즈 배지 5개마다 은색 배지 1개씩

Related topics