[이미지] 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. Ideal…

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…

반응(Reactions)을 이용해 배지 부여하기

커뮤니티 구축 데이터 및 보고

JammyDodger 10월 31, 2023, 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	520	8월 27, 2024
Badge SQL triggered on post content Data & reporting sql-triggered-badge	3	191	10월 9, 2026
What query to award a badge for liking or replying to a particular topic? Data & reporting sql-triggered-badge	1	677	5월 23, 2023
The default badge queries Data & reporting reference , sql-triggered-badge	1	1067	8월 27, 2023
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1143	3월 18, 2022

반응(Reactions)을 이용해 배지 부여하기

Related topics