I have this query below, which works in the data explorer , but I get the error Sorry, an error has occurred. when trying to use the query to assign badges. Is there something I’m missing here? The query should match if someone is a member of a group called “chapter_” or “meta_chapter_” and assigned …

For the Custom Triggered ones you need to add an extra line at the start and end. There’s an example in a post of mine above, and you can find more info in Create Triggered Custom Badge Queries :+1:

Thanks! I think I have to have a look after a good night sleep. SQL has been a while and I guess I have to check some more examples and docs. The thing below is not working, that’s for sure SELECT ub.id, ub.granted_at, g.name from user_badges ub INNER JOIN groups g ON ub.id = g.id WHERE g.name LIKE…

Explorerでは動作するが、バッジSQLでは動作しないバッジクエリ？

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

JammyDodger 2022 年 8 月 17 日午後 6:37 2

カスタムトリガーの場合は、最初と最後に余分な行を追加する必要があります。私の投稿に例があり、Creating triggered custom badge queries で詳細を確認できます

トピック		返信	表示
Grant a badge for all members of a group Data & reporting sql-triggered-badge	0	13245	2014 年 7 月 27 日
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	9	996	2022 年 4 月 17 日
Problem testing Badge Query from Data Explorer Data & reporting sql-triggered-badge	4	1036	2019 年 5 月 24 日
New "Meta" Badges Feature badges	1	738	2018 年 5 月 30 日
Creating Custom Badges and Triggers Data & reporting sql-triggered-badge	0	1679	2020 年 8 月 8 日

Explorerでは動作するが、バッジSQLでは動作しないバッジクエリ？

関連トピック