Hi, I’m trying to create a badge that is automatically granted, and I can’t find where to enter the SQL query while editing the badge. Is this somewhere else? Has the feature been removed? Any help is appreciated, of course. Thanks!

yeah - you have to enable them from the command line first, though. see this topic. [image] Enable Badge SQL Self-Hosting bookmark This guide explains how to enable Badge SQL in Discourse and discusses the associated security and performance risks. person_raising_hand Required user level: Administrator warning Enabling Badge SQL can pose security and performance risks. To maintain security and performance integrity, as of Discourse 1.6, the ability for administrators to edit badge SQL directly is disabled by default. The two primary concerns around enabling Badge SQL are: Security: Allowing direct SQL…

I see, thank you for sharing. Is this still the best way to grant custom badges automatically? Also, quick bit of feedback: I was searching for variations on “badge trigger” since a lot of the prior writing refers to triggers, but that post doesn’t have this so it didn’t show up in my searches. Maybe this will help somebody else.

[image] jsonnull: Is this still the best way to grant custom badges automatically? This remains the most efficient and timely way of automatically assigning badges based on a particular action on the forum. If you are happy with a 24 hour delay you can just bypass thinking about triggers and just use a badge query.

Are automatic badge triggers still available?

Product Support

tobiaseigen (Tobias Eigen) September 18, 2016, 3:09am 2

yeah - you have to enable them from the command line first, though. see this topic.

Topic		Replies	Views
"Trigger" text field not showing up when creating custom badge Product Support	3	1608	September 19, 2016
Set badges to be auto granted? Product Support badges , sql-triggered-badge	1	251	July 12, 2025
A Simple Way to Grant Badges en-masse? Product Support	1	1333	January 3, 2018
Where do I need to enter my Badge Query? Product Support sql-triggered-badge	1	1152	November 18, 2019
Creating custom badge with custom rules Data & reporting sql-triggered-badge	10	1943	March 14, 2023

Are automatic badge triggers still available?

Related topics