Sometimes I need to mention a specific group of people who replied to a specific topic into a new one. That’s because I’d like to involve them into a similar discussion [image] How can I do that quickly? Is there any particular query for that?

A little change to optimize that query (if you want to change the topic_id before execute it) -- [params] -- topic_id :topic_id = 18438 SELECT u.username FROM badge_posts p JOIN topics t ON p.topic_id = t.id JOIN users u ON p.user_id = u.id WHERE t.id = :topic_id GROUP BY p.user_id,u.username Note: replace 18438 for some topic_id from your forum :blush:

Why don’t you simply post in the topic, with a link to your other topic, and interested people can see and follow that link? Mentioning 26 people by @username seems a bit extreme.

Becuase a mention triggers a notification while just linking a topic would be overlooked By the way, generally I don’t have so many users and I don’t mention all the people but it’s useful to have the entire list. I know it would be useful just for “community” purpose so I asked if there is a quick way using some clever query

There is a badge query you can modify to make it work with Data Explorer plugin [image] A badge granted when someone posts a reply in a single specified topic Data & reporting 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”.

You don’t need that table because you really don’t want a badge. You want a list of users that replied to a specific topic. Probably you need the table “users”, but I’m not a query expert…

Done :slight_smile: and I can download via CSV SELECT u.username FROM badge_posts p JOIN topics t ON p.topic_id = t.id JOIN users u ON p.user_id = u.id WHERE t.id = '1010' GROUP BY p.user_id,u.username

Export a list of people who replied to a specific topic

Community Building Data & reporting

alefattorini (Alessio Fattorini) August 25, 2017, 9:52am 5

looks cool but I don’t have “badge_posts” table.
How can I make it work?

Topic		Replies	Views
What query to award a badge for liking or replying to a particular topic? Data & reporting sql-triggered-badge	1	691	May 23, 2023
Badge for replying to a topic in a specific category Data & reporting sql-triggered-badge	0	174	June 20, 2018
Unique list of topic participants? Product Support	2	158	October 4, 2024
A badge granted when someone posts a reply in a single specified topic Data & reporting sql-triggered-badge	7	534	June 19, 2018
Replied to topics in a certain category, but exclude replies to own topics Data & reporting sql-triggered-badge	2	184	October 28, 2015

Export a list of people who replied to a specific topic

Related topics