Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.I have a view with these relationships:
View base node: container
Relationship to purchase_contract
Relationship to shipment
The view is a table list that is embedded on a node display page (purchase_contract), with a contextual filter to show only containers that reference that purchase_contract node.
Among other fields from the container nodes, I'm also showing fields from the shipment each container is linked to. On one field, I needed the aliased path (because the "link to the referenced node" option is not available on the field I'm wanting to link) so I could rewrite the output and turn it into a link. I'm also using the aliased path to the container node, but the path for shipment has the "Shipment" reference specified for it.
The view (the page) works fine as long as all containers actually reference a Shipment, but it doesn't show any containers whose Shipment (reference) field is blank. On the relationship to Shipment, "Required" is *not* checked.
If I remove the Shipment: Path field, the view shows all containers as expected.
Comments
Comment #2
BerdirNot sure i understand that or what it has to do with pathauto. Pathauto doesn't have any views integration to display aliases, it doesn't load aliases or anything like that. It just generates them.
Check the generated views query. It's likely that some condition you add results in an inner join query.