That’s brilliant Owen, thanks!
For anyone else who might want the same query this works:
forEach(filter(value.parseJson().get("annotations"),a,a.get("types").length()==0),p,p.get("spot")).join("|")
1 Like