Hi folks, I’m stuck on my SQL query. My goal / expectation is that it should grant a specific custom badge immediately when a user replies to a particular topic. The thing is I’m halfway there because the Daily “Backfill” job succeeds though the more immediate effect is clearly not working. Our forum leverages the badge to provide access other categories (with some help from the automation plugin) so the End of Day/Backfill lag is pretty disorientating for the new users and definitely kills some momentum and enthusiasm upon joining up. I’ve been ignoring the issue for a while I’m ready to break down and ask for some help. I essentially lifted the query from the excellent post Creating triggered custom badge queries so it will probably look pretty familiar to most people. SELECT p.user_id, p.id post_id, p.created_at granted_at FROM badge_posts p WHERE p.topic_id = 11558 AND (:backfill OR p.id IN (:post_ids) ) or I’ve also tried SELECT DISTINCT ON (p.user_id) p.user_id, p.id post_id, p.created_at granted_at FROM badge_posts p WHERE p.topic_id = 11558 AND(:backfill OR p.id IN (:post_ids) ) Both work for the EOD backfill but lack the promptness I’m expecting. Here is a screenshot of the settings as currently set on the badge. [Screen Snippet of the bottom Discourse Badge Settings. Run Revocation Query Daily (optional) is Checked. Query targets posts (optional) is checked. The badge is also allowed to be used as a title and granted multiple times - both options are checked. All the badge visibility settings are checked also. The badge's trigger is "When a user acts on post" and the Badge is part of the Getting Started group.] When I check the error logs I see some Backfill failure logs from when I first implemented the query but I don’t see any logs regarding the query failing when a user posts. I’m probably just missing something obvious but I’ve squinted myself blind at this point so hopefully one of you will take pity on me and give me some pointers… or at least point me at some helpful documentation. Thanks in advance!

Haven’t tested yet, but I think the trigger should be “When a user edits or creates a post”? I think the one you have now = it fires on likes, flags, bookmarks, etc., not on post creation. Edit: tested it now and it works for me :slight_smile:

oooohhhh. I thought I’d tried all the permutations of those settings. But I just tested and that was it! You’ve sorted me out! So many months of playing the proverbial ostrich with my head in the sand and it was such a simple fix! What a fantastic experience this has been. Thanks @chapoi ____ For posterity… this was the fix. [Badge edit window is open and the Trigger dropdown is open. the mouse is hovering over the first option which reads "When a user edits or creates a post"]

关于我的触发式自定义徽章查询，需要一些帮助

产品支持

chapoi 2026 年2 月 5 日 09:15 4

呵呵，非常欢迎！

话题		回复	浏览量
Creating Custom Badges and Triggers Data & reporting sql-triggered-badge	0	1743	2020 年8 月 8 日
Creating triggered custom badge queries Site Management badges , how-to , sql-triggered-badge	0	13314	2014 年8 月 27 日
Badges for posting Data & reporting sql-triggered-badge	4	587	2024 年8 月 27 日
Badge SQL triggered on post content Data & reporting sql-triggered-badge	3	232	2026 年10 月 9 日
A badge granted when someone posts a reply in a single specified topic Data & reporting sql-triggered-badge	7	530	2018 年6 月 19 日

关于我的触发式自定义徽章查询，需要一些帮助

相关话题