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…

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. [02c298…

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:

[afbeelding] 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 w…

[afbeelding] JammyDodger: it seems that the auto badge granter will only award multiple badges if they’re based on specific posts So… even though the bronze badges are awarded based on posts… that doesn’t count, does it? [afbeelding] JammyDodger: I think in similar cases ‘escalating’ bad…

Hmmm. :thinking: I think I see where you’re going with this. Let me have another go… @ganncamp - I think we may have some success… :slight_smile: Based on Bronze Badge A being awarded through the post wrench or by giving a reason on the /admin/users/{user_id}/{username}/badges page: [post wrench…

Thanks @JammyDodger ! :tada: :tada: :tada: I’ve set this up on my test instance (not that I don’t trust you :joy:) and hope to put this in production this week! :star_struck: And… is this a good time to ask that the tutorial be updated with the things you’ve learned in this quest? :smiley:

[afbeelding] G Ann Campbell: (not that I don’t trust you :joy:) Oh for sure. Trust, but verify is definitely a smart choice. :slight_smile: [afbeelding] G Ann Campbell: And… is this a good time to ask that the tutorial be updated with the things you’ve learned in this quest? :smiley: …

Een zilveren badge voor _elke_ 5 bronzen badges

Gemeenschap Gegevens en rapportage

ganncamp (G Ann Campbell) 7 november 2023 om 18:20 14

Thanks @JammyDodger!

I’ve set this up on my test instance (not that I don’t trust you ) and hope to put this in production this week!

And… is this a good time to ask that the tutorial be updated with the things you’ve learned in this quest?

Topic		Antwoorden	Weergaven
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	9	1001	17 april 2022
Awarding badges multiple times with custom SQL Data & reporting sql-triggered-badge	3	1181	15 augustus 2023
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	270	17 januari 2024
SQL Querying in Badges Data & reporting sql-triggered-badge	2	1051	8 juni 2024
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	2	694	23 mei 2023

Een zilveren badge voor _elke_ 5 bronzen badges

Gerelateerde topics