I have a badge that my members can earn multiple times, it is a “Book Club” badge - they are awarded it for discussing the book of the month. Each month, a new topic is created about the next book, and everyone replying should get the badge - this is currently done manually and is a real pain. I w…

I think something like this could do it: WITH book_club_first_posts AS ( SELECT p.topic_id, p.user_id, MIN(p.id) AS post_id FROM posts p JOIN topics t ON t.id = p.topic_id WHERE t.category_id = 5 -- replace with the category_id of your book club AND p.deleted_at ISNULL AND …

カテゴリで新しいトピックに投稿するたびにバッジの質問か？

データとレポート

thoka (Thomas Kalka) 2024 年 4 月 4 日午後 5:20 5

I use a staging server for experiments.

トピック		返信	表示
A badge granted when someone posts a reply in a single specified topic Data & reporting sql-triggered-badge	7	354	2018 年 6 月 19 日
Badge for replies in a specific category Data & reporting sql-triggered-badge	3	190	2015 年 8 月 28 日
Badges for posting Data & reporting sql-triggered-badge	4	374	2024 年 8 月 27 日
Some common badge queries Data & reporting sql-triggered-badge	0	8722	2015 年 8 月 7 日
Awarding badges multiple times with custom SQL Data & reporting sql-triggered-badge	3	1157	2023 年 8 月 15 日

カテゴリで新しいトピックに投稿するたびにバッジの質問か？

関連トピック