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. [图片] 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.

[图片] 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) 2016 年9 月 18 日 03:09 2

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

话题		回复	浏览量
"Trigger" text field not showing up when creating custom badge Product Support	3	1605	2016 年9 月 19 日
Set badges to be auto granted? Product Support badges , sql-triggered-badge	1	251	2025 年7 月 12 日
A Simple Way to Grant Badges en-masse? Product Support	1	1333	2018 年1 月 3 日
Where do I need to enter my Badge Query? Product Support sql-triggered-badge	1	1147	2019 年11 月 18 日
Creating custom badge with custom rules Data & reporting sql-triggered-badge	10	1926	2023 年3 月 14 日

Are automatic badge triggers still available?

相关话题