[Answered ]-How to make a complex query in Django?

by

1👍

✅

I have created a pages app. look where is the template.

views.py

from django.shortcuts import render
from .models import Appeal
from django.db.models import Count


def index(request):
    qs = Appeal.objects.values(
        "organization__organization_name", "appeal_form__form_name"
    ).annotate(total=Count("appeal_form__form_name"))
    context = {
        "appeal": qs,
    }
    return render(request, "pages/index.html", context)

index.html

<table>
    <tr>
        <th>Organization</th>
        <th>Appeal Form</th>
        <th>Amount of appeals in this form</th>
    </tr>
{% for item in appeal %}
<tr>
    <td>{{ item.organization__organization_name }}</td>
    <td>{{ item.appeal_form__form_name }}</td>
    <td>{{ item.total }}</td>
</tr>
{% endfor %}
</table>

pages
├── __init__.py
├── admin.py
├── apps.py
├── migrations
├── models.py
├── templates
│   └── pages
│       └── index.html
├── tests.py
├── urls.py
└── views.py
👤A D

Leave a comment