I am working on a view where I need to show publications (a content type) in which authors (another content type) should be active (have a specific value for one of their fields).
I am using a relationship to add the fields for the node authors, and then add a filter criteria for checking if they are active or not. It is working in a way that is not what I want. It shows all the publications which has at least one active user (and maybe some other inactive users), but I want to have the ones in which all of authors are active.
What am I getting wrong here? could you please help me?