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 Creating 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年八月17日 18:37 2

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

話題		回覆	觀看
Grant a badge for all members of a group Data & reporting sql-triggered-badge	0	13363	2014年七月27日
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1114	2022年三月18日
Problem testing Badge Query from Data Explorer Data & reporting sql-triggered-badge	3	1095	2019年五月24日
New "Meta" Badges Feature badges	1	766	2018年五月30日
Creating Custom Badges and Triggers Data & reporting sql-triggered-badge	0	1722	2020年八月8日

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

相關主題