Where do i need to enter my Badge Query?

[srikanth]

What cool badge queries have you come up with?

• /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

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…