How can I retrieve all the related entries?

Question

I have 3 entries. One of the entries got the entries field where Ive attached the two other entries. Im trying to display all the related entries whether entry 1, 2 or 3 is chosen.

For example:

• Entry 1: Has the entries field. When this entry is selected, I need to show entry 2 and 3
• Entry 2: When this entry is selected I need to show entry 1 and 3
• Entry 3: When this entry is selected I need to show entry 1 and 2

Is this possible?

Answer 1

This is more tricky then I first thought. I hope this is what you need:

In case the current entry element is not the source of your relation, find that source entry first. This entry then goes into the relatedTo parameter of a new ElementCriteriaModel, where we exclude the current entry entry using its ID.

Code is probably more easy to understand than my wobbling english explanation:

<h1>{{ entry.title }}</h1>
{{ entry.body }}

{# Get `allRelatedEntries` if this `entry` is the "source element" of the relation #}
{% set allRelatedEntries = craft.entries.relatedTo({ sourceElement: entry }) %}

{# Get `allRelatedEntries` if this `entry` is the "target element" of the relation #}
{% if not allRelatedEntries|length %}
    {% set sourceElement = craft.entries.relatedTo({ targetElement: entry }).first() %}

    {# Any relations at all? #}
    {% if sourceElement %}
        {% set targetElements = craft.entries.relatedTo({ sourceElement: sourceElement }).id('not ' ~ entry.id).find() %}
        {% if targetElements|length %}
            {% set allRelatedEntries = targetElements|merge([sourceElement]) %}
        {% endif %}
    {% endif %}

{% endif %}

{% if allRelatedEntries|length %}

    <h2>Related Entries</h2>
    <ul>
        {% for relatedEntry in allRelatedEntries %}
            <li>{{ relatedEntry.title }}</li>
        {% endfor %}
    </ul>

{% endif %}

Answer 2

Here is a bare bones example of how I would deal with this.

I would essentially build an array of the ids I need and then retrieve the entries based on those IDs. It's an example of a technique I recently wrote about.

<h1>{{ entry.title }}</h1>
{{ entry.body }}

{# create empty array #}
{% set relatedItemsIds = [] %}

{# if entry field is not empty, merge entry ids into array #}
{% if entry.newsRelatedItems|length %}
  {% set relatedItemsIds = relatedItemsIds|merge(entry.newsRelatedItems.ids()) %}
{% endif %}

{# find source item in the relationship using the current entry #}
{% set sourceItem = craft.entries.section('news').relatedTo({
  targetElement: entry
}).first() %}

{# 
 # if source item is found
 # - merge its id to the array
 # - merge the ids of its target entries to the array but remove the current entry id from that merged array
 #}
{% if sourceItem %}
  {% set relatedItemsIds = relatedItemsIds|merge(craft.entries.section('news').id(sourceItem.id).ids()) %}
  {% set relatedItemsIds = relatedItemsIds|merge(sourceItem.newsRelatedItems.ids())|without(entry.id) %}
{% endif %}

{# use created array to retrieve an ElementCriteriaModel for the entries you need #}
{% set relatedItems = craft.entries.section('news').id(relatedItemsIds).fixedOrder(true).find() %}

{# display entries #}
<h2>Related entries</h2>
{% for entry in relatedItems %}
  <ul>
    <li><a href="{{ entry.url }}">{{ entry.title }}</a></li>
  </ul>
{% else %}
  <p>No related entries found</p>
{% endfor %}

Tested this code on my local sandbox. Can you check if it works for your use case ?