Relationship in expression engine?

Question

I have one channel called E. I have another channel called B.

I am trying to get my head around relationship in ee.

fields in channel E

1. title
2. url_title
3. e_name
4. e_description

fields in channel B

1. title
2. url_title
3. e_tag_b(relate to event e_name or title)
4. b_url

What I am getting in my last_segment is a url_title of channel E.Only this as my resource I want to get all the entries for channel B.

I read this doc,but i found it too confusing.

What I am doing :

{exp:channel:entries channel="B" }

    <h3>{e_tag_b:title}</h3>
    <p>{e_tag_b:b_url}</p>

{/exp:channel:entries}

I get consfused about what to loop when and which tag is to be related where.Any help?

Answer 1

It looks like you've forgotten to include your relationship field tag. Try this?

{exp:channel:entries channel="B" }

    {e_tag_b}
        <h3>{e_tag_b:title}</h3>
        <p>{e_tag_b:b_url}</p>
    {/e_tag_b}

{/exp:channel:entries}

Answer 2

Not sure I understand the question well but here is my take on it:

• Start with a url_title in your last segment
• Find the entry in channel E corresponding to that url_title
• Several entries in channel B are potentially related to that entry using the e_tag_b field. Following EE terminology, those entries are the "parents" of the entry in channel B
• Get the titles of those "parents" entries.

Let's try this

{exp:channel:entries channel="E" url_title="{last_segment}" limit="1" require_entry="yes"}

    <h1>{title}</h1>

    <p>Related (parents) entries:</p>

    {parents channel="B" field="e_tag_b"}
        {if parents:count == 1}<ul>{/if}
            <li>{parents:title}</a></li>
        {if parents:count == parents:total_results}</ul>{/if}
    {/parents}

{/exp:channel:entries}