[image] Are there problems with using flags to nominate posts for recognition? Ah. That’s a shame. I’ve been tinkering with ones based on certain Reactions, which seems quite promising. So ‘x amount of :medal_sports:’ per post, or a certain Reaction given by members of a certain group, etc. Ide…

Of course. :slight_smile: Basically, in its simplest form, you choose a Reaction which indicates ‘I think this deserves a badge’ which your members can use to nominate posts, and the query picks up which posts have picked up that Reaction. You can then either grant the badge manually from the list …

Thanks! I searched around a bit but couldn’t find a query that quite matches this, would you be willing to share the query? I’ve never created one myself but feel I need to learn this!

I have one that I was playing with, though I put it to one side to look at it with fresh eyes and haven’t got back to it yet, so it may need some work. It’s to award a badge based on getting at least 10 posts with the :chefs_kiss: reaction given by a member of the ‘data-team’ group for posts in the #…

Thanks that helped! This should probably be moved to a new topic since we’re derailing. But here’s the query I came up with (with the help of ChatGPT) that simply returns the users who gave/received the reaction, how many reactions, the date of reaction, and the url to the specific post. The only th…

[image] David Kingham: 'Your_Community_URL' || 't/' || rp.topic_slug || '/' || rp.topic_id || '/' || rp.post_number AS "Post URL" To get this bit to do its magic you append _url to the column name, so: 'Your_Community_URL' || 't/' || rp.topic_slug || '/' || rp.topic_id || '/' || rp.post_numb…

Utiliser les réactions pour attribuer des badges

Communauté Données et rapports

JammyDodger Octobre 31, 2023, 5:30 6

Pour que cette partie fasse sa magie, vous ajoutez _url au nom de la colonne, donc :

'Your_Community_URL' || 't/' || rp.topic_slug || '/' || rp.topic_id || '/' || rp.post_number AS post_url

Sujet		Réponses	Vues
Badges for posting Data & reporting sql-triggered-badge	4	520	Août 27, 2024
What query to award a badge for liking or replying to a particular topic? Data & reporting sql-triggered-badge	1	677	Mai 23, 2023
The default badge queries Data & reporting reference , sql-triggered-badge	1	1067	Août 27, 2023
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1143	Mars 18, 2022
Badge for poll vote + topic post with min post likes? Data & reporting polls , sql-triggered-badge	0	227	Août 13, 2019

Utiliser les réactions pour attribuer des badges

Sujets connexes