You may or may have not noticed this new badge: https://meta.discourse.org/badges/114/bug-reporter What I find super exciting about it is that there are zero plugins needed, I crafted it using our badges UI. Not only does it grant the badge daily, it will also grant it after one of the team “likes” a bug. It runs the following badge query: SELECT p.user_id, min(p.created_at) granted_at, MIN(p.id) post_id FROM badge_posts p JOIN topics t ON t.id = p.topic_id JOIN post_actions pa ON pa.post_id = p.id AND post_action_type_id = ( SELECT id FROM post_action_types WHERE name_key = 'like' ) AND pa.user_id IN ( SELECT gu.user_id FROM group_users gu WHERE gu.group_id = ( SELECT id FROM groups WHERE name ilike 'discourse' ) ) WHERE category_id = ( SELECT id FROM categories WHERE name ilike 'bug' ) AND p.post_number = 1 GROUP BY p.user_id The UI is still a tiny bit rough, but I find it super duper cool that the badge system is this extensible. Will knock up a silver version of this badge tomorrow and call it tester :bug: Thank you all for reporting bugs so diligently.

Just to clarify how this works for more lay-people (please correct me if I’m wrong): If a user in the group named discourse likes the first post in a topic in category bug then the badge is issued. Correct?

Is there a way to make this work in categories that aren’t publicly visible?

You would need to select from posts instead of badge_posts and basically reimplement the filters that view gives to avoid data leaks.

[image] sam: Will knock up a silver version of this badge tomorrow and call it tester Could you please post this query? :slight_smile: Can I select more teams? Like ‘discourse’ or ‘admins’ or ‘dev_team’ :smile: Last question, I can’t use markdown into Badge Description, how do you have created the link to discourse team?

Let me resurrect this thread again: @sam, could you post the query, please? This is interesting for a lot of different use cases, and my SQL has gotten quite rusty :wink:

did you read the first post :arrow_up:

It works like a charm already used on my forum

Yes, I did! I was referring to the silver version (requiring a specific number of likes), although my reply for some reason isn’t tagged as a reply to that specific post. Sorry for the confusion.

Just add HAVING count(*) > 9 to the end. HAVING is like WHERE, but applies after the GROUP BY.

What is the bug reporter badge?

Community Building Data & reporting

alefattorini (Alessio Fattorini) April 30, 2015, 8:11am 6

Could you please post this query?
Can I select more teams? Like ‘discourse’ or ‘admins’ or ‘dev_team’
Last question, I can’t use markdown into Badge Description, how do you have created the link to discourse team?

Topic		Replies	Views
Badge for posts with Likes from a specific group Data & reporting sql-triggered-badge	22	1146	August 27, 2023
Change system for Bug Reporter badge? Site feedback badges , sql-triggered-badge	12	547	February 24, 2026
Badges for specific category Feature	1	1324	June 13, 2018
The default badge queries Data & reporting reference , sql-triggered-badge	1	1124	August 27, 2023
Badges for posting Data & reporting sql-triggered-badge	4	577	August 27, 2024

What is the bug reporter badge?

Related topics