Django How to get a queryset from another queryset in a template

Question

I want to filter a queryset that depends on another queryset that already depends on another queryset

My models.py

class Escola(models.Model):
    id = models.AutoField(db_column='ID', primary_key=True)
    nome = models.CharField(db_column='Nome', max_length=255, blank=True, null=True)

class Inscrio(models.Model):
    id = models.AutoField(db_column='ID', primary_key=True)
    escolaid = models.ForeignKey(Escola, models.DO_NOTHING, db_column='EscolaID', blank=True, null=True)

class Utilizador(AbstractBaseUser)
    id = models.AutoField(db_column='ID', primary_key=True)
    inscriçãoid = models.ForeignKey(Inscrio, models.DO_NOTHING, db_column='InscriçãoID', blank=True, null=True)
    email = models.CharField(db_column='Email', max_length=255, blank=True, null=True, unique=True) 
    nome = models.CharField(db_column='Nome', max_length=255, blank=True, null=True)
    password = models.CharField(db_column='Password', max_length=500, default='pass');

USERNAME_FIELD = 'email'
EMAIL_FIELD = 'email'

My views.py

def view_forms(request):
   return render(request, 
                 "main/view_forms.html", 
                 {"escolas": Escola.objects.all(),
                 })

I am doing

{% for escola in escolas %}
   {% for inscrio in escola.inscrio_set.all %}
        {% for utilizador in inscrio.utilizador_set.all %}
            
            {{inscrio.id}}
            {{escola.nome}}
            {{utilizador.id}} 
        {% endfor %}
    {% endfor %}
{% endfor %}

I am currently trying to get the Inscrio data from Escola. But when I try to get the Utlizador data from the Inscrio I get nothing.

How can I do this?

Thanks in advance

user_2213675 · Answer

If I understand what you want, I think you are going about this backwards. Try this:

views.py:

def view_forms(request):
   return render(request, 
                 "main/view_forms.html", 
                 {"utilizadores": Utilizador.objects.all().order_by('inscriçãoid__escolaid__id'),
                 })

In your template:

{% for utilizador in utilizadores %}
        
        {{utilizador.inscriçãoid.id}}
        {{utilizador.inscriçãoid.escolaid.nome}}
        {{utilizador.id}} 
    {% endfor %}

I will update my answer if this isn't what you are looking for.

user_6693443 · Answer

I guess this is the worst way to do that. You're trying to render a table with utilizador's information from all escolas, so get it all and render it!. You can order it by escola id maybe.

query = Utilizador.objects.all().order_by('inscriçãoid__escolaid__id')

template
{% for q in query %}
    
    {{q.inscriçãoid.id}}
    {{q.inscriçãoid.escola.nome}}
    {{q.id}} 
{% endfor %}

Django How to get a queryset from another queryset in a template

2 Answers