I’m trying to award a badge depending on the content of a post. For example, If I type ‘Give Me A Badge’ i’m awarded the ‘Demanding’ badge. My SQL is as follows: SELECT p.user_id, p.id post_id, p.updated_at granted_at FROM badge_posts p WHERE p.raw LIKE '%Give Me A Badge%' AND (:backfill OR p.id IN (:post_ids) ) With ‘Query targets posts’ and ‘When a user creates or edits a post’. It’s not, however being triggered. The ’ Badge Query Preview’ shows hits for awards, but the site doesn’t appear to be awarding them. Help and advice welcome, please.

I’m unfortunately not able to reproduce :thinking: That said, I found a couple bugs in BadgeGranter that could prevent badges from being granted. FIX: improve badge granter resilience (#37674) main ← fix/badge-granter-resilience merged 03:31PM - 10 Feb 26 UTC (UTC) [תמונה] ZogStriP +51 -2 Two issues were found in BadgeGranter that could prevent badges from being grant…ed. First, `Array#compact!` returns `nil` when no elements are removed. For PostAction triggers, `[post_id, related_post_id].compact!` returns `nil` when `related_post_id` is present (nothing to compact), causing the post_ids payload to be silently lost. Using `compact` instead always returns the array. Second, `process_queue!` had no error isolation between badges. A single badge with a broken SQL query would raise an exception and abort processing of all remaining badges in the queue. Since queue items are already popped from Redis at that point, they are lost. Each badge is now rescued individually so one failure doesn't block the rest. https://meta.discourse.org/t/394444 Maybe once it’s merged, you could upgrade and try again?

any chances you could give more information about your setup and/or what you’re doing so that i can hopefully try to reproduce? :face_with_monocle:

Badge SQL triggered on post content

קהילה נתונים ודיווח

Alexander_Wright (Alexander Wright) 6 באוקטובר,‏ 2026,‏ 4:52pm 6

I’ve just checked, still no joy, sadly.

נושא		תגובות	צפיות
Badges for posting Data & reporting sql-triggered-badge	4	599	27 באוגוסט,‏ 2024
Creating triggered custom badge queries Site Management badges , how-to , sql-triggered-badge	0	13330	27 באוגוסט,‏ 2014
Need some Help with my Triggered Custom Badge Query Product Support sql-triggered-badge	3	197	5 בפברואר,‏ 2026
Creating Custom Badges and Triggers Data & reporting sql-triggered-badge	0	1746	8 באוגוסט,‏ 2020
Badge not working Data & reporting sql-triggered-badge	3	1552	9 ביוני,‏ 2016

Badge SQL triggered on post content

נושאים קשורים