I've encountered strange behavior of subquery - it seems to be some error of Bubble - or I missed something.
My query looks like this:
But result achieved:
all 5 users
However when I change subquery condition from "=" to "<>" like below:
Name <> "Patient"
Result is correct as expected:
Somone can explain what's wrong?