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 …

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. [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:

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

Серебряный значок за _каждые_ 5 бронзовых значков

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

ganncamp (G Ann Campbell) 26.Октябрь.2023 18:53:50 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	9	973	17.04.2022
Awarding badges multiple times with custom SQL Data & reporting sql-triggered-badge	3	1167	15.08.2023
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	261	17.01.2024
SQL Querying in Badges Data & reporting sql-triggered-badge	2	1038	08.06.2024
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	2	685	23.05.2023

Серебряный значок за _каждые_ 5 бронзовых значков

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