A badge granted when someone posts a reply in a single specified topic

[downey (Michael Downey)]

Anyone want a (hopefully easy) challenge? A badge granted when someone posts a reply in a single specified topic. (i.e., A “Please introduce yourself here” topic.)

[riking (Kane York)]

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 = 32 AND -- 32 is the "please introduce yourself" topic
  (:backfill OR p.id IN (:post_ids) )

Triggered on “edit/create a post”.

[Frasertag (James Fraser)]

Hi

I am seeking some help to do the following badge

I am trying to encourage users to post in a thread, I want them to post in this particular thread 10 times to earn this badge.

I was looking at

@riking

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 = 32 AND – 32 is the “please introduce yourself” topic
(:backfill OR p.id IN (:post_ids) )

Which works for a single post, I am just unsure how to expand this out to 10 posts minimum.

[Nigel_Tatschner]

Can’t seem to get this to work,
I’ve added;

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 = 172 AND
(:backfill OR p.id IN (:post_ids) )

But running the query isn’t bringing anyone back

[riking (Kane York)]

Did you change the topic ID? the 172

[Nigel_Tatschner]

@riking

Did you change the topic ID? the 172

Yeah, I think 172 is the topic number.

[Timothy_Vail]

@riking

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 = 32 AND – 32 是“请自我介绍”的主题
(:backfill OR p.id IN (:post_ids) )

在新的 SQL 规则下，如何为在某个主题中自我介绍创建一个徽章？

[yanokwa (Yaw Anokwa)]

我使用了这个查询…

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 = 6671 AND -- 6671 是“自我介绍”主题
  (:backfill OR p.id IN (:post_ids) )

使用以下设置