Custom order related entries

Question

is it possible to replicate the order of related entries in the front end as they appear in the admin entries panel? (see images below)

Right now, in the front end it only sorts the order in which the entries where originally entered (sorted by entry date & time).

If not is there any other possibility to do so? Thanks

Answer 1

The natural sort order for related entries is the order defined in the control panel (not the post date of the related entries), unless you otherwise specify the sort order. Here is an example taken from one of my projects, where related articles are defined within an entries field-type in an article entry:

{% set relatedArticles = entry.relatedArticles %}
<ul>
    {% for article in relatedArticles %}
        <li><a href="{{ article.url }}">{{ article.title }}</a></li>
    {% endfor %}
</ul>

On the backend, craft uses the table craft_relations to create the relationship with the columns sourceId, targetId, and sortOrder. This sortOrder column defines the default sort order when accessing related entries through the related 'entries' field-type.

If on the other hand, you are accessing related entries using the .relatedTo() method of the EntryCriteriaModel then you will need to specify the sort order using .order('sortOrder').

Update

Here is the original code:

{% set relatedRecords = craft.entries.section('contenuDiscographie').relatedTo(entry) %} 
{% for record in relatedRecords %} 
    <a href="{{ record.url }}">{{ record.title }}</a>    
    {% for block in record.discoArtistes %}    
        {% set relatedPerformers = craft.entries.section('interpretes').relatedTo(block) %}
        {% for performer in relatedPerformers %}     
            {{ performer.title }}
        {% endfor %}    
    {% endfor %} 
{% endfor %}

Try using the actual relationship field:

{% set relatedRecords = entry.myRelatedEntriesFieldHandle %} 
{% for record in relatedRecords %} 
    <a href="{{ record.url }}">{{ record.title }}</a>    
    {% for block in record.myMatrixBlockFieldHandle %}
        {% set relatedPerformers = block.myRelatedEntriesFieldHandleInsideMatrixField %}
        {% for performer in relatedPerformers %}      
            {{ performer.title }}
        {% endfor %}    
    {% endfor %} 
{% endfor %}

Edit I edited the code above to be more generic, rather than trying to guess what the field handles are named in your project. You need to change these to your actual field handles. From the picture above I would guess they might be 'entry.relatedRecords', 'record.discoArtistes', and 'block.nom' for example.

Answer 2

Set the order parameter to 'sortOrder':

{% set entries = craft.entries.relatedTo(entry).order('sortOrder') %}

or do simply use the short syntax:

{% set entries = entry.entriesFieldHandle %}

Answer 3

After testing the above solution by Douglas

1) If the related entries are not in a Matrix block the following works perfectly. You may put the related entries in any custom order by dragging them around.

{% set relatedPerformers = entry.performer.order('sortOrder') %}

2) The related entries coming from a Matrix field gives following error: Craft\MatrixBlockModel and its behaviors do not have a method or closure named "relatedPerformers".

{% set relatedPerformers = block.performer.order('sortOrder') %}

Answer 4

Try this(sorted by 'title'):

{% for entry in relatedEntries|sort((a, b) => a.title <=> b.title) %}
    <a href="{{ entry.url }}">{{ entry.title }}</a><br>
{% endfor %}

Twig docs: Sorts an array