How do I make my own badge query?

[Pad_Pors]

there is a topic describing other badges:

[Superseded] What cool badge queries have you come up with?

Enabling Badge SQL entails security and performance risks so it is not available by default. For more information, see: Enable Badge SQL This topic became too long to be easily searched and has been broken down into separate topics. If you have any questions about how to write a badge query, or have one to share, please start a new topic in the data & reporting category and tag it with the sql-triggered-badge tag. More ideas: Some common badge queries

the faq topic for badge (which may not be what you want):

What are Badges?

Badges in Discourse reinforce positive user behaviour and facilitate “learning by doing”. It is a central part of Discourse’s gamification features. [image] Receiving Badges There are two ways to receive a badge: Manually granted by an administrative user Automatically granted by the system Furthermore, all badges have some optional properties. Allow badge to be used as a title Can be granted multiple times Show badge on the public badges page Show post granting badge on badge page C…

creating badge:

Grant a badge to individual users manually

In this guide we’ll be creating a new “Scholar” badge that we will grant to individual users manually. Let’s get started! This guide is only applicable for custom badges. To manually grant one of Discourse’s built in badges, you will need to follow: Bulk Award a badge to a set of users Create a new custom badge Create a new custom badge from the Admin > Badges page by clicking on “New” button. [new_badge] Fill out badge details In our example, I am naming the badge “Scholar”…