Django template nested for loop

Question

I have 2 tables:

Table1: [A-Foriegn Key, field1]
Table2: [Table1-Foriegn Key, field2]

I want to display a list with distinct values of Table1 field1 if items are present in Table2. and inside that list I want to display all the elements of Table2 corresponding to that field1 of Table1.

I am trying :

{% for t1 in Table1 %}
   Display field1 of t1
   {% for t2 in Table2 %}
      Display field2 of t2.
   {% endfor %}
{% endfor %}

Table 1:

╔════╦══════════════╦══════╗
║ Id ║  EventName   ║ FK   ║
╠════╬══════════════╬══════╣
║  1 ║ Christmas    ║  56  ║
║  2 ║ Black Friday ║  18  ║
╚════╩══════════════╩══════╝

Table 2:

╔════╦══════════════╦══════╗
║ ID ║  Image       ║ FK   ║
╠════╬══════════════╬══════╣
║  1 ║ image1_url   ║  1   ║
║  2 ║ image2_url   ║  1   ║
║  3 ║ image3_url   ║  2   ║
║  4 ║ image4_url   ║  2   ║
╚════╩══════════════╩══════╝

I want to display : Christmas and BlackFriday in a list.

And on clicking element from the list, I want to display all url for that particular event. Like on clicking Christmas: image1_url and image2_url should be displayed.

I dont want to make AJAX requests.

Can you give sample data in table and sample output?

clement
– clement

2017-06-27 06:42:53 +00:00
Commented Jun 27, 2017 at 6:42 — clement
– clement, Commented Jun 27, 2017 at 6:42
I have added sample data.

Abhishek Lodha
– Abhishek Lodha

2017-06-27 07:12:19 +00:00
Commented Jun 27, 2017 at 7:12 — Abhishek Lodha
– Abhishek Lodha, Commented Jun 27, 2017 at 7:12

Nimantha · Accepted Answer · 2021-12-27 12:34:46Z

5

You can use foreign key mappings in the templates to reference objects.

Suppose you have two tables Table1 and Table2, with a mapping like Table1 -> Table2, with a foreign key field in Table2 referencing Table1, you can do something like this:

Your views.py would be something like this:

table1 = Table1.objects.all() 
table2 = Table2.objects.all() 
return render('template_name.html',{'table1':table1, 'table2':table2})

then your html template will be like:

{% for table1Instace in table1 %}
    
    {% for table2Instance in table1Instace.table2_set.all %}
    
    <!--Print table elements here-->
    
    {% endfor %}

{% endfor %}

where your table2Instance will be an objects of the row(s) in table2 corresponding to their foreign key mapping in table1.

edited Dec 27, 2021 at 12:34

Nimantha

6,5376 gold badges32 silver badges78 bronze badges

answered Jun 27, 2017 at 8:13

Rudresh Panchal

1,0106 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Prabhakar Shanmugam Over a year ago

Two minor corrections to the above answer. May be the query for Table 2 is not required. Also in templates we cannot use () after 'all()'. This is similar to using '.items()' in view and simply 'items' in templates.

Abhishek Lodha Over a year ago

table1Instace.table2_set.all can i get first element from this list

Gopi Kirupanithi · Accepted Answer · 2017-06-27 10:25:58Z

1

models.py

class Category(models.Model):
    name = models.CharField(max_length=45, blank=True)

class Items(models.Model):
    name = models.CharField(max_length=45, blank=True)
    rate = models.FloatField(default=0)
    category_id = models.ForeignKey(Category)

views.py

def test_category(request):
    s = Category.objects.all()
    return_dict = {
        's' :   s        
    }
    return render(request, 'base.html', return_dict)

{% for item in s%}
    {{ item.name }}
    {% for x in item.items_set.all %}
        -- {{ x.name }}
    {% endfor %}
{% endfor %}

answered Jun 27, 2017 at 10:25

Gopi Kirupanithi

531 silver badge7 bronze badges

1 Comment

Abhishek Lodha Over a year ago

s must be queryset of Items.

Collectives™ on Stack Overflow

Django template nested for loop

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related