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…

[imagen] 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

Insignia basada en cuándo fue la primera promoción de usuario a moderador?

Comunidad Datos e informes

jrgong (jrgong) 22 Abril, 2024 09:59 8

Sí, se supone que es automático. Básicamente, solo queremos establecer varias insignias para los moderadores (1 año, 2 años, 3 años, etc.) según el tiempo que lleven como moderadores y otorgarles insignias automáticamente.

Tema		Respuestas	Vistas
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1150	18 Marzo 2022
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	723	23 Mayo 2023
Automatic badge expiration Support badges	7	1624	16 Septiembre 2023
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	317	17 Enero 2024
SQL Querying in Badges Data & reporting sql-triggered-badge	1	1100	4 Diciembre 2015

Insignia basada en cuándo fue la primera promoción de usuario a moderador?

Temas relacionados