"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

Badge SQL can no longer be edited by default

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 allows them raw access to the database, generally we are opting that raw access to the database from the web UI is a feature you opt-in for. Even though the queries only return user_ids, an admin attacker can discover any information in the database using badge queries. If column A of table Y has the le…

[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.