"Trigger" text field not showing up when creating custom badge

[evanthemann7]

I am trying to create new automatic badges for my community. I am an admin and last week I was able to type SQL into a box called “Trigger (SQL Badge Query)” but now that box does not show up.

I found a similar thread, but refreshing does not fix it for me. That thread was called “Not displayed Trigger Options in Admin Panel for badges”. I tried to link here but it wouldn’t let me since I’m a new user.

Thanks

[cpradio]

You will want to read this

Enable Badge SQL

Enabling Badge SQL entails security and performance risks. Starting from Discourse 1.6 badge SQL can no longer be edited by admins unless explicitly enabled. This change was made for a couple of reasons: Security: Allowing admins to enter SQL directly grants them raw access to the database. Generally, we opt that raw access to the database from the web UI as a feature you opt-in for. Even though the queries only return user_ids, an admin attacker can discover any information in …

[evanthemann7]

Thanks, good info to know.

What is the best way to contact @team to get this feature enabled?

[jomaxro (Joshua Rosenfeld)]

You could send a PM to team here (you need to reach TL1 first), or simply email team@discourse.org which will do the exact same thing.