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…

[image] 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.

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 based on when user was promoted to moderator first time?

Community Building Data & reporting

JammyDodger April 22, 2024, 11:50am 9

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)

Topic		Replies	Views
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1150	March 18, 2022
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	723	May 23, 2023
Automatic badge expiration Support badges	7	1624	September 16, 2023
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	316	January 17, 2024
SQL Querying in Badges Data & reporting sql-triggered-badge	1	1099	December 4, 2015

Badge based on when user was promoted to moderator first time?

Related topics