Query results are not what was expected

[ppicazo1]

You see below I am in production and there are only three conditions to be met and all of them are AND conditions not OR, yet you can see the location has eighteen locations

starting off with (empty).  Can someone tell me why those eighteen show up?  The last ANDed condition says Location is not empty.  Above the conditions it says

“All of these conditions must be met”, but it looks to me like they are not.  Why?

[SVimes · Accepted solution]

I see this in cases where the reference field in question was populated at one time but that reference no longer exists. When I look at an XML of the record, I can see there is a value, but it isn't a valid reference anymore. Since I inherited an old instance, I ended up adding an additional filter where I dot-walk into the reference for anything at all. Since the reference isn't valid, there isn't anything to dot-walk into and ends up being excluded by the filter.