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…

Badge 查询在 Explorer 中可以运行，但在 Badge SQL 中不行？

社区数据与报告

JammyDodger 2022 年8 月 17 日 18:37 2

对于自定义触发器，您需要在开头和结尾添加额外的行。我上面的一篇帖子中有一个示例，您可以在 Creating triggered custom badge queries 找到更多信息

3 个赞

话题		回复	浏览量
Grant a badge for all members of a group Data & reporting sql-triggered-badge	0	13223	2014 年7 月 27 日
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	9	972	2022 年4 月 17 日
Problem testing Badge Query from Data Explorer Data & reporting sql-triggered-badge	4	1024	2019 年5 月 24 日
New "Meta" Badges Feature badges	1	733	2018 年5 月 30 日
Creating Custom Badges and Triggers Data & reporting sql-triggered-badge	0	1667	2020 年8 月 8 日

Badge 查询在 Explorer 中可以运行，但在 Badge SQL 中不行？

相关话题