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-te…

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' R…

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) 6월 11, 2026, 12:48오후 4

@chapoi 정말 잘 작동했어요, 다시 한번 감사합니다

글		댓글	조회수
A badge granted when someone posts a reply in a single specified topic Data & reporting sql-triggered-badge	7	440	6월 19, 2018
Grant Badge when user visits link Data & reporting sql-triggered-badge	26	1403	8월 30, 2023
Custom badge query is not targeting posts Support	1	779	1월 2, 2019
Grant a badge for all members of a group Data & reporting sql-triggered-badge	0	13346	7월 27, 2014
Some common badge queries Data & reporting sql-triggered-badge	0	8909	8월 7, 2015

배지 SQL을 토픽 ID에 연결하는 방법?

Related topics