Hi everyone, I’m planning on installing the Discourse Solved tomorrow morning but I have a question around the awarding of badges to users for having posted answers when they get marked as solved. I wanted to have a full understanding of how this works before I embark on deployment to my Discourse, but I can’t seem to find a single topic which explains the process to me in full. My understanding thus far is: Install the plugin Rebuild the app Enable the hidden Badge SQL via the console options Create some new badges, I wish for three: Bronze = First accepted answer Silver = 10x accepted answers Gold = 25x accepted answers Copy and paste the Badge SQL from here - IN TO WHERE? Edit the SQL and change > 9 to be > 24 in order to allow for my Gold ‘25x solved badge’ What I can’t seem to work out is how do I then ‘link’ the badges I’ve created, to the Badge SQL code? I’ve not yet enabled the Badge SQL feature so perhaps it will become apparent then, but I’m guessing there must be a way in which I can choose which badge gets assigned for the sql? Is my bronze/silver/gold badge wish possible? And last but not least, if my understanding of this is correct, the recipients of the badges will only receive them on a daily cron job, they’re not instant. Is this job in place as part of a wider job, or do I need to also create this job? Thanks in advance for any insight and advice!

Until you enable the sql you can’t use sql. You can have badges triggered by posts so they are awarded immediately.

A question re the Solved plugin and Badge SQL

Richie (Richie Rich) 13 באוקטובר,‏ 2018,‏ 7:58pm 3

No, that’s ok, I’m happy for them to be issued automatically on a daily basis.

I just wanted to know if there was anything else I had to do in order to enable this to happen.

נושא		תגובות	צפיות
Do these new badges come bundled with the plugin? Product Support solved	6	778	12 במרץ,‏ 2023
Add Badge to Solve answer Feature solved	3	3277	26 בינואר,‏ 2018
Is it possible to have a badge for 100 solutions? Data & reporting solved , sql-triggered-badge	6	540	8 באוקטובר,‏ 2023
Badge not being applied, sql error Bug solved	1	2366	14 בדצמבר,‏ 2018
Solved badges are now enabled by default for new communities Announcements solved	4	455	16 ביולי,‏ 2026