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. [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 only…

[图片] 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? [图片] JammyDodger: I think in similar cases ‘escalating’ badges can work wel…

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

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:

[图片] G Ann Campbell: (not that I don’t trust you :joy:) Oh for sure. Trust, but verify is definitely a smart choice. :slight_smile: [图片] 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: I shall see i…

每5个铜徽章获得一个银徽章

社区数据与报告

ganncamp (G Ann Campbell) 2023 年11 月 7 日 18:20 14

感谢 @JammyDodger！

我已经在我自己的测试实例上设置好了（不是我不信任你），希望这周就能投入生产！

而且……是不是现在问一下，能否将你在此过程中学到的东西更新到教程中呢？

话题		回复	浏览量
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1025	2022 年3 月 18 日
Awarding badges multiple times with custom SQL Data & reporting sql-triggered-badge	2	1193	2017 年10 月 25 日
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	283	2024 年1 月 17 日
SQL Querying in Badges Data & reporting sql-triggered-badge	1	1058	2015 年12 月 4 日
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	698	2023 年5 月 23 日

每5个铜徽章获得一个银徽章

相关话题