I am using Drupal7 (updating to Drupal9 soon). I created a Drupal View that uses 8 different (chained) Relationships to access a specific entity type (A). Then, the view displays some fields of this entity type A. The view has some filter criteria as well (making sure the fields of A are not deleted), and a Contextual filter on the logged in user’s Drupal ID.
The first relationship of that View takes the Drupal user ID and makes available a "person" entity with this ID. Then, for example, this person entity has a (second) relationship to their employer, and the employer has a (third) relationship to all the "Cases" they have. I want to access these Case entities in my View, and display some of their attributes (fields).
Now my problem is that all of the Drupal views I created this way only give back one result (Case) each. Specifically, they return only the fields of the "first" Case entity (Case entity with the lowest Case ID) that meets the given filter criteria.
I tried to remove some of the Relationships for the View, to check if a list of entities is reduced to its first item somewhere along the way through the Relationships. But the problem already appears in the first Relationship that is supposed to output multiple values. I didn’t find any helpful resources on that in the net.
Why is Drupal Views behaving like that? How can I include all of the results?
I also appreciate hints for better search words for this problem.
