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年十一月7日 18:20 14

感谢 @JammyDodger！

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

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

話題		回覆	觀看
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1117	2022年三月18日
Awarding badges multiple times with custom SQL Data & reporting sql-triggered-badge	2	1234	2017年十月25日
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	311	2024年一月17日
SQL Querying in Badges Data & reporting sql-triggered-badge	1	1084	2015年十二月4日
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	715	2023年五月23日

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

相關主題