[画像] 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. Ideall…

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…

[画像] 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_number …

リアクションを使用してバッジを付与する

コミュニティデータとレポート

JammyDodger 2023 年 10 月 31 日午後 5:30 6

これを機能させるには、列名の末尾に _url を追加します。たとえば次のようになります。

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

トピック		返信	表示
Badges for posting Data & reporting sql-triggered-badge	4	519	2024 年 8 月 27 日
Badge SQL triggered on post content Data & reporting sql-triggered-badge	3	191	2026 年 10 月 9 日
What query to award a badge for liking or replying to a particular topic? Data & reporting sql-triggered-badge	1	677	2023 年 5 月 23 日
The default badge queries Data & reporting reference , sql-triggered-badge	1	1065	2023 年 8 月 27 日
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1143	2022 年 3 月 18 日

リアクションを使用してバッジを付与する

関連トピック