I’d like to automatically apply certain badges to users in certain groups. In searching the forum , it appears this may be possible via SQL queries, etc. We are on the hosted plan, so that is not possible. In talking with Discourse support, it appears a solution might be to make an app/script that us…

[afbeelding] apautler: We are on the hosted plan, so that is not possible. It is possible on hosted plans, just let us know by emailing team@discourse.org and we can enabled them.

@sam Gotcha. What do you think is the better option though? Is it dangerous to begin making SQL queries from within the hosted platform? Makes me a bit nervous because there are other admins in our account and I worry if they accidentally do something in the currently hidden SQL area, it could serio…

If this is a once off I would just make the badges, let us know when you are done and then disable badge SQL. Should be fine. I think it makes sense to extend groups to, optionally, automatically grant a badge, so SQL is not involved. You can also do this via the API but it would require running …

Is there a way to paste an example code that we can upload on our site? Is user1 is added to groupX, award badgeX Simple, nothing more to it

Here is the badge SQL, just replace your_group_name select user_id, created_at granted_at, NULL post_id from group_users where group_id = ( select g.id from groups g where g.name = 'your_group_name' )

This will run via the scheduler correct? It is not triggered be the group add, but just runs daily and awards based on group membership?

In the badge settings you need to set the trigger to daily and select the option for revocation daily [Screenshot_20171002-232556]

@scombs , I had posted in another thread, and someone responded almost at the same time. The code is slightly different. Do you know what the difference would be? main difference is: gu. vs g. Other poster’s code: SELECT gu.user_id, gu.created_at AS granted_at, null AS post_id FROM group_user…

Not sure. I saw the other post too. Here is the howto with the code [afbeelding] Grant a badge for all members of a group Data & reporting I just created a badge for all the awesome plugin authors . Creating a badge targeting a group is quite easy, just type …

Should be the same as I explained there. :slight_smile:

Automatically Apply Badges to Group Members (in Hosted Version)

Ondersteuning

scombs (Steve Combs) 4 oktober 2017 om 00:00 10

Not sure. I saw the other post too.

Here is the howto with the code

Topic		Antwoorden	Weergaven
How to allocate badge when user joins group Support	2	1056	15 mei 2019
Can Group Owners award Badges? Support badges	11	1313	19 februari 2021
What if badges could optionally synchronize group membership? Feature badges , groups , completed	13	2162	11 oktober 2023
Can I create a plugin that checks users and grant access to group based on activity? Development	10	1353	29 augustus 2017
Grant a badge for all members of a group Data & reporting sql-triggered-badge	0	13267	27 juli 2014

Automatically Apply Badges to Group Members (in Hosted Version)

Gerelateerde topics