I have this SQL in the settings of a badge and it awards a badge to anyone that gets added to the beta-testers group: SELECT u.id AS user_id, CURRENT_TIMESTAMP AS granted_at FROM users u INNER JOIN group_users gu ON gu.user_id = u.id INNER JOIN groups g ON g.id = gu.group_id WHERE g.name = 'beta-testers' Can I modify that to also link the badge to a specific topic ID? :thinking:

I think you can: SELECT u.id AS user_id, CURRENT_TIMESTAMP AS granted_at, (SELECT id FROM posts WHERE topic_id = YOUR_TOPIC_ID AND post_number = 1) AS post_id FROM users u INNER JOIN group_users gu ON gu.user_id = u.id INNER JOIN groups g ON g.id = gu.group_id WHERE g.name = 'beta-testers' Replace YOUR_TOPIC_ID And it has to have Query targets posts ticked I think. Lmk if that works.

Thanks @chapoi, I’ve applied that change. If I click the [Preview granted badges] button it’s looking good, and it’s showing me the topic it will tie the badge to. I’ll reply back in the next 24hrs when they’ve been issued :crossed_fingers:t2:

@chapoi that worked a treat, thanks again :smiley:

将徽章 SQL 链接到主题 ID？

产品支持

Richie (Richie Rich) 2026 年6 月 11 日 12:48 4

@chapoi 效果非常好，再次感谢

话题		回复	浏览量
A badge granted when someone posts a reply in a single specified topic Data & reporting sql-triggered-badge	7	532	2018 年6 月 19 日
Grant Badge when user visits link Data & reporting sql-triggered-badge	26	1709	2023 年8 月 30 日
Custom badge query is not targeting posts Product Support	1	818	2019 年1 月 2 日
Grant a badge for all members of a group Data & reporting sql-triggered-badge	0	13465	2014 年7 月 27 日
Some common badge queries Data & reporting sql-triggered-badge	0	9143	2015 年8 月 7 日

将徽章 SQL 链接到主题 ID？

相关话题