Disabling the option ‘Give this badge more than once’ is not working, at least with SQL-triggered badges.
I have three badges with this option disabled that get triggered automatically many times.
I had a very big issue because of it, so I’m here reporting that this was not an isolated case but probably a buggy behavior.
If possible, please post the badge sql, as well as screenshots of the badge settings, for example these settings:
(moved this topic to Support until we can at least confirm it’s not the config)
Just jumping in here as I’ve run into the same issue. I’ve also disabled the “Give this badge more than once” setting on several SQL-based badges, but they keep getting awarded repeatedly. It would be helpful to know if anyone has found a workaround or if this is confirmed as a bug. I can share my badge SQL, too,o if needed.
please post the sql and your badge settings so i can confirm the configuration is correct and attempt to replicate the issue.
SELECT
gs.user_id,
current_timestamp AS granted_at
FROM
gamification_scores gs
WHERE
(:backfill OR gs.user_id IN (:user_ids))
AND gs.date >= (current_date - interval '1 month')
AND NOT EXISTS (
SELECT 1
FROM user_badges ub
WHERE ub.user_id = gs.user_id
AND ub.badge_id = YOURIDOFBADGE
)
GROUP BY
gs.user_id
HAVING
SUM(gs.score) > 11
I have only selected ‘Show on public badges page’ and ‘revoke daily’. The activator is recurrent daily.