Hey guys! I tried search, but could not find anything. Is there any way to assign a badge based on how long a user has been a moderator? In our case, we have mods who have been an essential part of the team for many years and we want to give them a special badge. Basically the query should check …

Haven’t tried setting up as badge sql, but here is a data explorer query for getting the moderator days as their role: WITH moderator_role_dates AS ( SELECT gu.user_id, MIN(gu.created_at) AS role_granted_date FROM group_users gu JOIN groups g ON gu.group_id =…

I’ve just tagged this as sql-triggered-badge , but thought I’d check as if you’re looking for an automatic one or not? I’m assuming you may not have a huge amount of mods and could maybe grant this badge manually based on a data explorer query? I think a simplified version of the one above could b…

[immagine] JammyDodger: but thought I’d check as if you’re looking for an automatic one or not? Yep, supposed to be automatic. Basically, we just want to set multiple badges for moderators (1 year, 2 years, 3 years etc) based on how long they have been a mod and grant them badges automaticall…

I think the one above is adaptable if you remove the parameter and change the WHERE to be the different day thresholds for each, eg. WHERE days_as_mod > 365 (The trigger would be update daily)

Thx, technically we could do that, but as long as we can do it automatically in a way that doesn’t compromise security, we will rather opt for that. :slight_smile: I really appreciate the code and we will try and implement it together with our hoster CommuniteQ and report back here

Badge basato sulla prima promozione a moderatore?

Comunità Dati e reportistica

JammyDodger 22 Aprile 2024, 11:50am 9

Penso che quello sopra sia adattabile se rimuovi il parametro e cambi il WHERE per essere le diverse soglie di giorni per ciascuno, ad esempio.

WHERE days_as_mod > 365

(Il trigger sarebbe update daily)

Argomento		Risposte	Visualizzazioni
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1150	Marzo 18, 2022
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	723	Maggio 23, 2023
Automatic badge expiration Support badges	7	1627	Settembre 16, 2023
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	317	Gennaio 17, 2024
SQL Querying in Badges Data & reporting sql-triggered-badge	1	1100	Dicembre 4, 2015

Badge basato sulla prima promozione a moderatore?

Argomenti correlati