Relationships¶

Child Entries: Displaying the Stores and their Menus¶

First things first. We need to write a page to list each Store and which pizzas they have to offer. We do that with this template:

{exp:channel:entries channel="stores"}
        <h1>{title}</h1>
        <p>Phone: {phone}</p>
        <p>Address: {address}</p>
        <h2>Specialty Pizzas</h2>
        {specialty_pizzas}
                <h3>{specialty_pizzas:title}</h3>
                <p>{specialty_pizzas:description}</p>
                <p>{specialty_pizzas:ingredients}</p>
        {/specialty_pizzas}
{/exp:channel:entries}

We start with the standard {exp:channel:entries} tag, pulling from the Stores channel. For each Store entry we display the Store name, the Store’s phone number and its address. Then we display which specialty pizzas are available:

<h2>Specialty Pizzas</h2>
{specialty_pizzas}
        <h3>{specialty_pizzas:title}</h3>
        <p>{specialty_pizzas:description}</p>
        <p>{specialty_pizzas:ingredients}</p>
{/specialty_pizzas}

The {specialty_pizzas} tag is a Relationship variable tag. Since it is a relationship that can take multiple entries, it is a looping tag pair. So these three lines, contained in the pair, will be looped over:

<h3>{specialty_pizzas:title}</h3>
<p>{specialty_pizzas:description}</p>
<p>{specialty_pizzas:ingredients}</p>

The variables will be replaced for each Pizza entry that is attached to the current Store entry. In those lines {specialty_pizzas:title} will be replaced by the title of the current Pizza entry, {specialty_pizzas:description} will be replaced by its description and so on.

Notice that what we’re doing here is prefixing the names of the variables in the Pizza channel with the name of the Relationship field that relates the Store channel to the Pizza channel. We call this namespacing and it’s a very powerful tool. This is what allows us to access the variables of the related entries, even though they may be the same as those of the parent entries.

Inside the {specialty_pizzas} tag pair, you can use {title} to display the title of the current Store entry and {specialty_pizzas:title} to display the title of the current Pizza entry. This means we can nest relationships as deeply as we want to with out having to worry too much about naming collisions.

Parent Entries: Which Stores have Which Pizza?¶

Another template you might want to make is a page for each pizza where you give a description of the pizza, list its ingredients and show which stores currently have the pizza available. You can do this with the {parents} tag. Like so:

{exp:channel:entries channel="pizzas"}
        <h2>{title}</h2>
        <p>{description}</p>
        <p>{ingredients}</p>
        <h3>Where can I find this pizza?</h3>
        {parents field="specialty_pizzas"}
                <strong>{parents:title}</strong>: <br />
                {parents:phone} <br />
                <p>{parents:address}</p>
        {/parents}
{/exp:channel:entries}

In this template we list the Pizza channel’s variables – {title}, {description} and {ingredients}. Then we have a section to show in which stores this pizza is currently available. To accomplish this, we use the {parents} tag.

The {parents} tag will pull entries that have the current Entry from the {exp:channel:entries} tag as a child through the field that you specify. If you use the same field group in multiple channels, you may want to also specify the channel. In this case, we’re passing it the specialty_pizzas field. It will look for all entries attached to any channel through the specialty_pizzas field that have the current Pizza entry as a child. In our case, specialty_pizzas is only used in the Stores channel and this will have the result of finding all Stores that currently have this Pizza available.

The {parents} tag is a looping tag pair. So for each Store it finds, it will loop over the section of template contained in the pair:

<strong>{parents:title}</strong>: <br />
{parents:phone} <br />
<p>{parents:address}</p>

It will replace that section’s variables and append it to the final output. Here, we use namespacing again to access the parent Store’s variables. We access its title, phone and address using parents:title, parents:phone, and parents:address.

Child Entries: Upcoming Shows¶

The first thing we tackle is creating a listing of upcoming shows and the bands that are playing in them. We assume the Show entry is set to expire the day after the show, so we don’t have to worry about any date stuff for now. Here’s what that template might look like:

{exp:channel:entries channel="shows"}
        <div class="show">
                <h2><a href="{path="shows/index"}/{url_title}">{title}</a></h2>
                <div class="show-body">
                        <div class="what"><label>What</label>{what}</div>
                        <div class="when"><label>When</label>{when}</div>
                        <div class="who">
                                <label>Who's playing?</label>
                                {bands}
                                        <div class="band"><strong>{bands:title}</strong> {bands:style}</div>
                                {/bands}
                        </div>
                </div>
        </div>
{/exp:channel:entries}

Most of this should look pretty familiar to you if you’re familiar with the channel:entries tag. But notice this section:

<div class="who">
        <label>Who's playing?</label>
        {bands}
                <div class="band"><strong>{bands:title}</strong> {bands:style}</div>
        {/bands}
</div>

This section uses the Relationships field. On the publish page, we attached the Bands that are going to playing this Show to the Show’s entry. With the {bands} tag, we are now looping over those bands. For each Band entry attached to the Show entry, we append this line of the template with the variables replaced:

<div class="band"><strong>{bands:title}</strong> {bands:style}</div>

In each loop, we replace the Band’s name {bands:title} and what style of music they play {bands:style}. Again, the namespacing of relationships with the relationship tag name allows us to specify which title we want, in this case, the Band’s and not the Show’s.

Parent Entries: A Band’s Recent Shows¶

Now we want to build a page for each Band. And on that page, we want to display all the Shows that Band has played. To do this, we need a parent tag:

{exp:channel:entries channel="bands" limit="1"}
        <div class="band">
                <h2>{title}</h2>
                <span class="style">{style}</span>
                <p>{history}</p>
                <div class="members">
                        {members}
                                <div class="member">
                                        <a href="{path="musicians/index"}/{members:url_title}">{members:first_name} {members:last_name}</a>
                                </div>
                        {/members}
                </div>
                <div class="shows">
                        <h3>Recent Shows</h3>
                        {parents channel="shows" field="bands"}
                                <div class="show">
                                        <strong>{parents:title}</strong>
                                        <div class="what">{parents:what}</div>
                                        <div class="when">{parents:when}</div>
                                </div>
                        {/parents}
                </div>
        </div>
{/exp:channel:entries}

The part to notice is this bit:

<div class="shows">
<h3>Recent Shows</h3>
{parents channel="shows" field="bands"}
        <div class="show">
                <strong>{parents:title}</strong>
                <div class="what">{parents:what}</div>
                <div class="when">{parents:when}</div>
        </div>
{/parents}
</div>

Here, we use the {parents} tag to access this Band’s parent entries in the Shows channel. It will cycle through each Show that has this particular Band entry as a child through the bands field and display this part of the template for that Show entry:

<div class="show">
        <strong>{parents:title}</strong>
        <div class="what">{parents:what}</div>
        <div class="when">{parents:when}</div>
</div>

Parent Entries: A Musician’s Bands¶

On the musician page, we want to be able to display the bands a musican currently plays with. To do that, we use the {parents} tag again. Here is the template:

{exp:channel:entries channel="musicians" limit="1"}
        <div class="musician">
                <h2>{first_name} {last_name}<h2>
                <div class="instruments">
                        {instruments}
                </div>
                <div class="biography">
                        {biography}
                </div>
                <div class="past-bands">
                        <ul>
                        {parents field="members"}
                                <li class="band-name"><a href="{path="bands/index"}/{parents:url-title}">{parents:title}</a></li>
                        {/parents}
                        </ul>
                </div>
        </div>
{/exp:channel:entries}

The relevant section is this:

<div class="past-bands">
        <ul>
        {parents field="members"}
                <li class="band-name"><a href="{path="bands/index"}/{parents:url-title}">{parents:title}</a></li>
        {/parents}
        </ul>
</div>

Here we use the {parents} tag to access the Band entries that this Musician is a member of. Since the members field is only used in the Band channel we do not need to specify the channel. It will only pull Bands.

Child Entries: Showing Games and Teams in a Season¶

The first thing we do is show all games and teams in a particular season. The ‘Spring 2013’ season. While we’re at it, lets list all the players on each team, so that players know which team they’ve been placed on. The template might look something like this:

{exp:channel:entries channel="seasons" title="Spring 2013" limit="1"}
        <div class="season">
                <h2>{title}</h2>
                <h3>Teams</h3>
                <div class="teams">
                        {teams}
                                <div class="team">
                                        <h4>{teams:title}</h4>
                                        {teams:players}
                                                <span class="player">{teams:players:first_name} {teams:players:last_name}</span>
                                        {/teams:players}
                                </div>
                        {/teams}
                </div>
                <h3>Games</h3>
                <div class="games">
                        {games}
                                <div class="game">
                                        <h4>{games:title}</h4>
                                        {games:home:title} vs {games:away:title}
                                </div>
                        {/games}
                </div>
        </div>
{/exp:channel:entries}

Let’s break that down to see what we are doing. The first thing you see is the good old channel entries tag:

{exp:channel:entries channel="seasons" title="Spring 2013" limit="1"}

We pull a single entry from the Seasons channel. The one titled “Spring 2013”. Just inside of that we see our standard {title} tag to pull the title of the entry. After that things get more interesting:

{teams}
        <div class="team">
                <h4>{teams:title}</h4>
                {teams:players}
                        <span class="player"><span class="number">{teams:players:number}{teams:players:first_name} {teams:players:last_name}</span>
                {/teams:players}
        </div>
{/teams}

Notice, the tag name teams is the same as our relationship field name in the Seasons channel. This is a Relationship tag. It works very similarly to the channel:entries tag. It will loop over the entries you have assigned to the teams field on the publish page and use them to replace the variables contained.

Here, things differ a little bit from standard channel entries. We need a way to separate the related entry’s variables from your channel:entries tag’s variables. To accomplish this we prefix the variables of the related entries with the name of the field they belong to. So:

<h4>{teams:title}</h4>

In that bit of code, we’re accessing the title of the entry from the Teams channel related to our current Season through the teams field. This is very powerful. It allows you to relate entries even from the same channel to each other and still access their variables. Say you wanted to add a field for the previous and next seasons to a season’s entry. You could give it a previous and next field. In your channel:entries tag you might access them like this:

{exp:channel:entries channel="seasons" url-title="winter-2013" limit="1"}
        <a href="{path="seasons/index"}/{previous:url_title}">{previous:title}</a>
        <a href="{path="seasons/index"}/{next:url_title}">{next:title}</a>

Even though all the variables would be the same, you can easily access any variable from the current entry or either of the related entries.

Prefixing variables this way also allows us to access nested relationships. Look back up to our previous example. Notice this bit of code:

{teams:players}
        <span class="player">{teams:players:first_name} {teams:players:last_name}</span>
{/teams:players}

In our Teams channel you’ll notice that we have a relationship field to the Players channel that can take multiple entries. We access those entries through the {teams:players} tag. This works exactly the same as the {teams} tag. It’s an entries loop tag. Except in this case, we’re getting the entries that were assigned to our current Team. We can access the Player channel’s variables in the same way as we do our Team channel’s variables, by prefixing them:

<span class="player">{teams:players:first_name} {teams:players:last_name}</span>

You may also have noticed that in some places we wrap our relationship in an open and close tag, like we did above with players:

{teams:players}
        <span class="player">{teams:players:first_name} {teams:players:last_name}</span>
{/teams:players}

In other places, however, we don’t. We just access the relationship’s variables directly using the prefixing, like we did with the home and away fields:

{games}
        <div class="game">
                <h4>{games:title}</h4>
                {games:home:title} vs {games:away:title}
        </div>
{/games}

In the above example, home and away are relationship fields in the Games channel. However, they are limited to a single entry. In that case, you can access the relationship’s variables directly, at any time, by adding the prefix. There’s no need to specify the bit of your template you want to loop over. There can only be one!

Child Entries: Showing Details of a Game¶

Let’s try another example. Let’s say you need another page on this league website that shows the details of a single game: when, who played and who won. That template might look something like this:

{exp:channel:entries channel="games" limit="1"}
        <h2>{home:title} ({home_score}) vs {away:title} ({away_score})</h2>
        <p>In this game the {home:title} played the {away:title}.</p>
        <p>The final scores were {home:title} with {home_score} and {away:title} with {away_score}.</p>
        <p>Playing for {home:title} were:</p>
        <div class="players">
                {home:players}
                        <span class="player">#{home:players:number} {home:players:first_name} {home:players:last_name}</span>
                {/home:players}
        </div>
        <p>Playing for {away:title} were:</p>
        <div class="players">
                {away:players}
                        <span class="player">#{away:players:number} {away:players:first_name} {away:players:last_name}</span>
                {/away:players}
        </div>
{/exp:channel:entries}

Here, the {exp:channel:entries} tag accesses the Games channel. The first thing we do is display which teams are playing and what the score was. We do that by going through the home and away fields which both point to the Teams channel. We grab the title ({home:title} and {away:title}) and display it.

Further down we list the players on each team using {home:players} and {away:players}. Since the players field is a multiple relationship, we need a tag pair. But notice that we don’t need to be the {home:players} tag itself inside a {home} pair. {home} takes a single entry, and so we can just use it as a prefix to access its custom field variables.

Inside the {home:players} and {away:players} pairs we can access the field variables of the Players channels by prefixing them with home:players or away:players respectively. So, inside {home:players} we can get the Player’s first name, last name and number with {home:players:first_name}, {home:players:last_name} and {home:players:number}.

Parent Entries: Showing A Team’s History¶

Say you had a Team page where you showed details of a particular team and you wanted to show all Games that team had played in. You could accomplish this like so:

{exp:channel:entries channel="teams"}
        <div class="games"><ul>
                {parents field="home|away"}
                        <li>{parents:home:title} ({parents:home_score}) vs {parents:away:title} ({parents:away_score})</li>
                {/parents}
        </ul></div>
{/exp:channel:entries}

In this case, we have two different fields in the parent channel that relate to the Teams channel: home and away. We want to pull from both of them, so in our {parents} tag field parameter we use field="home|away". Here the channel parameter is unnecessary as neither home or away is used in any channel other than Games.

Sibling Entries: Navigating Between Games¶

What if you wanted to have a series of pages showing the details of a single game? On these pages, you want to show a navigation section, showing other games from the current season. You could accomplish this by using channel:entries for the Seaons channel and walking down to games. But that would require an if tag to determine whether the game we’re showing in navigation is the current game. An easier way to accomplish this would be to use the siblings tag, like so:

{exp:channel:entries channel="games"}
        <div class="navigation"><ul>
                {siblings channel="seasons" field="games"}
                        <li>{siblings:title}    - {siblings:home:title} vs {siblings:away:title}</li>
                {/siblings}
        </ul></div>
{/exp:channel:entries}

The siblings tag pulls all entries in the Games channel that are related to the Seasons channel through the games field, except for the current one. The current entry in the Games channel that the channel:entries tag has pulled up must be related to the channel through the field given to the siblings tag. Otherwise it won’t work.

Usage: Multiple Related Entries¶

Given the following channel layout:

ParentChannel
        title
        url_title
        field1                                  Text
        field2                                  Text
        relationship_field              Relationship (ChildChannel, Multiple)


ChildChannel
        title
        url_title
        field1                                  Text
        field2                                  Text

You would access the child entries in your template using the following syntax:

{exp:channel:entries channel="parentChannel"}
        {title} - {field1} - {field2}
        {relationship_field}
                {relationship_field:title}
                {relationship_field:field1}
                {relationship_field:field2}
        {/relationship_field}
{/exp:channel:entries}

The section of the template that belongs to the relationship_field:

{relationship_field}
        {relationship_field:title}
        {relationship_field:field1}
        {relationship_field:field2}
{/relationship_field}

Will be looped over. It acts very similarly to a channel:entries tag.

Usage: Single Related Entries¶

Given the following channel layout, where relationship_field is limited to taking a single child entry:

ParentChannel
        title
        url_title
        field1                                  Text
        field2                                  Text
        relationship_field              Relationship (ChildChannel, Single)


ChildChannel
        title
        url_title
        field1                                  Text
        field2                                  Text

You would access the child entry in your tempalte using the following syntax:

{exp:channel:entries channel="parentChannel"}
        {title} - {field1} - {field2}
        {relationship_field:title}
        {relationship_field:field1}
        {relationship_field:field2}
{/exp:channel:entries}

No looping occurs.

Parameters¶

The following parameters are available on any looping child tag in order to further filter or sort the entries being retrieved. They function the same as they do when used on the {exp:channel:entries} tag. The available parameters are:

• backspace
• offset
• orderby
• sort
• entry_id
• author_id
• channel
• group_id
• url_title
• username
• status

Usage¶

Given the following channel layout:

ParentChannel
        title
        url_title
        field1                                  Text
        field2                                  Text
        relationship_field              Relationship (ChildChannel, Multiple)


ChildChannel
        title
        url_title
        field1                                  Text
        field2                                  Text

You can access siblings of the current entry in {exp:channel:entries} tag using the following syntax:

{exp:channel:entries channel="childChannel"}
        {siblings field="relationship_field"}
                {siblings:title} - {siblings:field1} - {siblings:field2}
        {/siblings}
{/exp:channel:entries}

The {siblings} tag does not need to be a top level tag. It may be used from a nested relationship in order to access that relationship’s siblings. The syntax is:

{exp:channel:entries channel="parentChannel"}
        {relationship_field}
                {relationship_field:siblings field="relationship_field"}
                        {relationship_field:siblings:title}
                {/relationship_field:siblings}
        {/relationship_field}
{/exp:channel:entries}

Parameters¶

The following parameters are available on the {siblings} tag in order to further filter or sort the entries being retrieved. They function the same as they do when used on the {exp:channel:entries} tag. The available parameters are:

• backspace
• offset
• orderby
• sort
• entry_id
• author_id
• channel
• group_id
• url_title
• username
• status

In addition, the following parameters may be used:

{siblings field="relationship_field"}

{siblings channel="parentChannel" field="relationship_field"}

Usage¶

Given the following channel layout:

ParentChannel
        title
        url_title
        field1                                  Text
        field2                                  Text
        relationship_field              Relationship (ChildChannel, Multiple)


ChildChannel
        title
        url_title
        field1                                  Text
        field2                                  Text

You can access the parents of the current entry in a channel:entries tag using the following syntax:

{exp:channel:entries channel="childChannel"}
        {parents field="relationship_field"}
                {parents:title} - {parents:field1} - {parents:field2}
        {/parents}
{/exp:channel:entries}

The {parents} tag may be accessed through nested relationships tags using the following syntax:

{exp:channel:entries channel="parentChannel"}
        {relationship_field}
                {relationship_field:parents field="relationship_field"}
                        {relationship_field:parents:title}
                {/relationship_field:parents}
        {/relationship_field}
{/exp:channel:entries}

Parameters¶

The following parameters are available on the {parents} tag in order to further filter or sort the entries being retrieved. They function the same as they do when used on the {exp:channel:entries} tag. The available parameters are:

• backspace
• offset
• orderby
• sort
• entry_id
• author_id
• channel
• group_id
• url_title
• username
• status

In addition, the following parameters may be used:

{parents field="relationship_field"}

{parents channel="parentChannel" field="relationship_field"}