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…

[imagem] 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 automatically. …

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

Distintivo baseado em quando o usuário foi promovido a moderador pela primeira vez?

Comunidade Dados e relatórios

jrgong (jrgong) Abril 22, 2024, 9:59am 8

Sim, supostamente é automático. Basicamente, queremos definir vários emblemas para moderadores (1 ano, 2 anos, 3 anos, etc.) com base em quanto tempo eles são moderadores e conceder-lhes emblemas automaticamente.

Tópico		Respostas	Visualizações
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1150	18 de Março de 2022
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	723	23 de Maio de 2023
Automatic badge expiration Support badges	7	1624	16 de Setembro de 2023
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	316	17 de Janeiro de 2024
SQL Querying in Badges Data & reporting sql-triggered-badge	1	1100	4 de Dezembro de 2015

Distintivo baseado em quando o usuário foi promovido a moderador pela primeira vez?

Tópicos relacionados