[Django]-How do I access the properties of a many-to-many "through" table from a django template?

by

41👍

✅

The easiest way is just to pass the band to the template. Templates are capable of navigating the relationships between models and there is both members and membership_set queryset managers on Group. So here is how I would do it:

view:

def group_details(request, group_id):
    group = get_object_or_404(Group, pk=group_id)
    return render_to_response('group_details.html',
                              {'group': group})

template:

<h2>{{ group.name }}</h2>
{% for membership in group.membership_set.all %}
    <h3>{{ membership.person }}</h3>
    {{ membership.date_joined }}
{% endfor %}
👤Rory Hart

7👍

I’m not sure whether it’s only solution or not, but passing relation objects to the template certainly works. In your view, get QuerySet of Membership objects:

rel = Membership.objects.filter( group = your_group ).select_related()

and pass it to template, where you can iterate over it with {% for %}

{% for r in rel %}
     {{ r.person.name }} joined group {{ r.group.name }} on {{ r.date_joined }}<br />
{% endfor %}

Note that this should not perform any additional queries because of select_related().

👤cji

0👍

Rory Hart’s answer is mostly correct. It allows you to use intermediate (through) table in the ManyToMany relationship.

However, the loop in the template should be modified using select_related as cji suggests, in order to avoid hitting the database with additional queries:

<h2>{{ group.name }}</h2>
{% for membership in group.membership_set.select_related %}
    <h3>{{ membership.person.name }}</h3>
    {{ membership.date_joined }}
{% endfor %}
👤Quique

Leave a comment