I was just informed that what I thought is a bug is actually meant to be like this. Since it makes zero sense to me I’d like to suggest it as a Feature request.
From my example:
I have a table “Documents” and a Table “User”.
I have two linked fields to between the two, one where only one user can be added to the document and one where multiple can be added (Owner and collaborators)
In my document record, I want to see all linked users who do not have an E-Mail Adress in their Profile. This is the Filter for the User list on my Document Record Page:
ID (user) = Document → Owner (user ID)
AND
E-Mail = empty
OR
ID(user) is one of Document → Collaborators (User ID List)
And E-Mail = Empty
This works until there are no collaborators linked to the Document. Then suddenly, noloco decides to ignore half the filter condition and show all Users without E-Mail Adress, even if they are not linked to the Document record in question at all.
I think this is a very questionable implementation. If the linked field is empty to begin with, no record ID is returned and thus no records should be shown. But simply ignoring the condition because the linked field is empty but then concindering it again when its not empty makes no sense.
