Where do I need to enter my Badge Query?

[srikanth]

@PJH

• /admin/badges
• + New
• Give your badge a name
• Pick an icon. The font-awesome names can be found here ( fa-pencil-square for example) or use a hosted image. This will be used on the various badges pages dotted around your site.
• Pick an (optional) image. You can use the same as the previous step. This image will appear on user cards.
• Select a badge type. For this you’d probably want Bronze.
• Pick a group (or create a new group for it first.)
• Give your badge a description
• Enter the following sql

I have followed the above steps to create my own badge.

But unfortunately, i’m unable to find a field to enter my badge SQL query in the new Badge screen.
I’m using v2.3.5 discourse.

Can someone help me out.

[dax (Daniela)]

See

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 …