Query 'Preview' not working in SQL badge page

[JammyDodger]

@Firepup650

Weird It still doesn’t work for me. I’ll try running it against a few other groups to see if I can find the issue.

Edit: Ran against a different group, and the query still failed. I’m not sure what the issue here would be. Does it depend on primary groups by chance?

Edit 2: That wouldn’t work, staff doesn’t seem to be allowed to be set as a primary group.

Just to note, if you’re using the Preview I think it may not be working. I noticed some issues with it when building a badge recently.

[Lilly]

oh dear. Thanks for the update. I am having fun though!

All my badge queries are failing in the previewer but working in Data Explorer. I’m sitting here looking at table schemas and going crosseyed

[Firepup650 (Firepup Sixfifty)]

Ah. That might be why then. I was running them on the preview. I felt like I was chasing a ghost bug somewhere

[JammyDodger]

@Lilly

I am interested to work with her when I know the badge query previewer is working.

We do have a fix in the pipeline for that.

FIX: Badge preview not displaying grant count